I have a button my my main form that, when clicked will trigger a macro that will open a table, copy all records, close the table, go to a new record on the subform and paste.
I can get it all, EXCEPT I can’t make the booger go to the subform. I’ve used GoToControl without success. Opening it causes it to open independently, not as a subform. What am I missing for the Control Name for the GoToControl function. I think my syntax must be off.
I’ve tried Forms![YPPA Order Form].Form![sbfrmYPPADirOrderDetails]
AND
Forms(“YPPA Order Form”)(“sbfrmYPPADirOrderDetails”)
