I created a form that only uses the subform for data entry. I cannot seem to figure out how to get the cursor to go to new record when I open the main form. Subform is a datasheet view.
I created a form that only uses the subform for data entry. I cannot seem to figure out how to get the cursor to go to new record when I open the main form. Subform is a datasheet view.
in the main form current event put
Me![putyourSubformControlNamehere].SetFocus
DoCmd.GoToRecord , , acNewRec