Entering new record on form

  • Thread starter Thread starter Diane
  • Start date Start date
Hi Diane

On the On Open event of the form insert the following:

DoCmd.GoToRecord , , acNewRec

Assuming you're using Access 2000

HTH

Debra
 
How do I make the form go to a new record as I open it so
it is ready to fill in.
Click to expand...

Two possibilities:

- If you JUST want to enter data, and don't want to even see old
records, set the DataEntry property of the Form to True.

- If you want to default to entering new records, but still want the
ability to scroll back and see old ones, put the following VBA code in
the Form's Open event (by viewing the form's properties, finding the
Open event on the Events tab, clicking the ... icon and choosing Code
Builder):

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