Open form to new record

[goodkat]

I'm a little rusty with Access, and I'm learning Access 2007. I am trying to
open a form to a new record, not to the first record, but I want to be able
to scroll back through the records, so the Data Entry property isn't what I
need. Any ideas?

 

[goodkat]

I found it - I don't know if there is an easier way, but in the coding for
the button to open the form, I put: DoCmd.GoToRecord , , acNewRec

 

[John W. Vinson]

I found it - I don't know if there is an easier way, but in the coding for
the button to open the form, I put: DoCmd.GoToRecord , , acNewRec

That'll usually work, but for safety's sake specify what object you mean. You
might have some other form opening:

DoCmd.GoToRecord acDataForm, "nameoftheform", acNewRec

explicitly specifies WHAT you want to do.