Open form and jumping to new record

J

John Vinson

How to do this? The wizard doesn't give me this option, it appears.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top