When adding a button to a form, how do you inform the user to go to a specific field?
Okay, I've created a data entry form in Access 2003. I included a click button for a user to add a new customer to the database. What I am trying to figure out how to do is once the user clicks on the button, the form should take the user to the first data entry field (where the blinking cursor should be). The code is partially working in that it will bring up a blank view of the form with no data present so I know I am about to add a new record. But if I am not familiar with form data entry, I may not know how to navigate around. I want to avoid this by forcing the cursor to go directly to the first data entry field so the user will know to start adding data there.
This is what I have so far for code:
Private Sub AddNewRecord_Click()
DoCmd.GoToRecord, acNewRec
End Sub
Thanks for any suggestions.
Jake
|