Record on Form Open

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

Guest

When I open a Form, the record that is displayed is No1 on the DB, can I set
the form to display a 'blank' or 'new' record on opening ?
Thanks
 
Three ways
1. Set the form DataEntry Property to Yes
====================================
2. On the On open form command line, specify that it for data entry
docmd.OpenForm "FormName",,,,acFormAdd
====================================
3. On the OnLoad event of the form, insert the code to move to a new record
DoCmd.GoToRecord , , acNewRec
 
Back
Top