M
Manuel
I have what I think is a real simple question. I have a form with several
subforms on various tabs. What I want to do is have the form automatically
go to a new record when the user clicks on the tab. I understand that this
can be accomplished by setting the Data Entry property on the Sub Forms to
TRUE, but I want the users to be able to navigate back to earlier entries
using the forms navigation buttons.
So, how would I do this?
I tried inserting the below code in the OnOpen Event of the subform, but
received an error message:
DoCmd.GoToRecord acDataForm, "Forms!MainForm!Tracking_Form", acNewRec
Placing the code in the GotFocus Event does nothing.
I would appreciate any assistance you’ll can provide.
Thanks!
Manuel
subforms on various tabs. What I want to do is have the form automatically
go to a new record when the user clicks on the tab. I understand that this
can be accomplished by setting the Data Entry property on the Sub Forms to
TRUE, but I want the users to be able to navigate back to earlier entries
using the forms navigation buttons.
So, how would I do this?
I tried inserting the below code in the OnOpen Event of the subform, but
received an error message:
DoCmd.GoToRecord acDataForm, "Forms!MainForm!Tracking_Form", acNewRec
Placing the code in the GotFocus Event does nothing.
I would appreciate any assistance you’ll can provide.
Thanks!
Manuel