Forms

[Guest]

Can a form be set up so that when someone opens it to put new data in, it
goes to the blank new record, and doesnt start out on the first record?
Thanks,
Jimmy

 

[Guest]

Can a form be set up so that when someone opens it to put new data in, it
goes to the blank new record, and doesnt start out on the first record?
Thanks,
Jimmy

Yes.

For the form propery On Open create the following event

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

 

[Guest]

On the On open form command line, you can add to it so it will open a new
record
Docmd.OpenForm "FormName",,,,acFormAdd

In that case you wont be able to move to previous record
=======================================
If you want to open a new record, and still have the ability to move to an
old record, on the OnLoad event of the form you can add the command to move
to a new record

Docmd.GoToRecord , , acNewRec