Open form to new record

  • Thread starter Thread starter goodkat
  • Start date Start date
G

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?
 
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
 
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
Click to expand...

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.
 
Back
Top