People when open the form see the first record? How can I let them open a blank fields (New record).
People when open the form see the first record? How can I let them open a blank fields (New record).
Set the DataEntry property to YES.
Glad you got it sorted.
you can also make an On Load or On Open Even Procedure.
you can go to a new record with the command
docmd.GoToRecord,,acNewRec
and set the forms Key Preview Event to Yes and On Key Down event to:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case 33, 34
KeyCode = 0
End Select
End Sub
in this way, the they cannot use the page up and down to move to any records.