Open form and jumping to new record

  • Thread starter Thread starter Yair Sageev
  • Start date Start date
How to do this? The wizard doesn't give me this option, it appears.
Click to expand...

If you ONLY want to see the new record (and those records entered
during the time the form has been open, but no older ones) set the
Form's DataEntry property to True.

If you want to jump to the new record but still be able to browse
through existing ones you'll need just a single line of VBA code: in
the Form's Load event put

Private Sub Form_Load(Cancel as Integer)
DoCmd.GoToRecord,,acNewRecord
End Sub
 
Back
Top