Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Jimmy Ferguson said:
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
Click to expand...

Yes.

For the form propery On Open create the following event

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub
 
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
 
Back
Top