Access - New Record on Subform (Docmd or RunCommand) from that form's Tabbed Form
Posted on 2012-12-20
I have a Main form on that main form I have
1 subform (with it's own subform) AND also
1 Tabbed Form with the tabs of the Tabbed Form having Subform's on them.
I am attempting to transfer info
One of the Tabbed Form's Subform
The other Subform of the Main Form
When I click a command button on one of the Tabbed Forms Sub it is transferring the data to the other MainForm's Sub but I can not get it to go to a new record on that form.
When i use Docmd
I get an error
Run-Time error 2498
An Expression you entered is the wrong data type for one of the arguments.
DoCmd.GoToRecord , Forms![frm_Inv]![frm_ctl_MiscInv].Form![sfrm_dta_MiscInvDetails], acNewRec
If I put quotations around the Form name I get the object. xxxxxxxx isn't open.
If I put Open/Close parenthesis around it (no quotations) I get the same "wrong argument" error.
How can I correct it?