How to make form show user empty new record 1

[saraUSIT]

How do I code a form that it will show the user an empty new record when user opens form? I don't want them to have to click on the new record button to get to a new page.

Thanks

 

[pjm]

Set the "Data Entry" property of the form to "Yes".
HTH
pjm

 

[missinglinq]

pjm's advice will work if you only want to add new records, but you cannot then view existing records.

Yo go to a new record on opening and be able to view existing records use this:

Private Sub Form_Load()
   DoCmd.GoToRecord , , acNewRec
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!