Hey all - I have a form with several fields. After filling all the fields for one record, I click the Right arrow automatically provided by Access to add that record and go to a new one. The cursor does not go back to the top, so I added the following code:
Private Sub Form_AfterInsert()
facName.SetFocus
End Sub

While that sets the focus to the correct field at the top of the form, it no longer takes me to a new, blank record. Some help please.
Thank you,
Nora

Change the tab index of your controls.
The lowest indexed control is automatically the first one that has the focus when you move to a record, and when you move to the next control from the control with the highest index, the next record is selected (a new record in data entry, or if the record you are leaving is the last record in the table or is a new one) provided that you have the options set to cycle through records, rather than cycling through the controls.

When you create a form, the controls are given sequential tab indices by the order in which you add them to the form.

On the View menu, there is a Tab Order selection which gives you a really nice means of adjusting the indices in a really helpful drag-N-drop dialog.