You cant go to specified record

[deb]

I have a form with an Add Record button.
When the button is clicked when first entering the form, I works great.
When the 1st record is entered and the button is clicked again to enter
another record, I get a msg "You cant go to specified record." I click the
OK button and then...
I am able to click the Add Record button and it works.

I even have Me.AllowEdits = True
Me.AllowAdditions = True in the code

Please Please help

 

[VicRauch]

I believe that if you add this line of code at the top of the code for your Add Record button, it should work.

DoCmd.RunCommand acCmdSaveRecord

 

[deb]

I love the simple solutions...especially when they work perfectly!!!

Thank you!!

 

[deb]

I love the simple solutions...especially when they work perfectly!!!

Thank you!!

 

[deb]

I love the simple solutions...especially when they work perfectly!!!

Thank you!!

 

[deb]

I spoke too soon...

Now when I open the form and click on the Add New button, I get

The command or action Save Record isn't available now.

 

[VicRauch]

Deb,

Put "On Error Resume Next" right in front of the "Save Record" line, then right after the "Save Record" line, put "On Error Goto 0" Sorry I didn't get this the first time. So much for Perfect.