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")
This conversation is currently closed to new comments.
Communicating with sub-forms has been a problem with me for years - and I'm glad there are other experienced users having similar problems.
Now I write seperate queries that deliver what I want (containing a common synchronized field) within eachform and copy their SQL code into the Row Source property.
After much trial and error, I got it to work using just "sbfrmYPPADirOrderDetails". Talk about overworking it...
Thanks for your commiseration, Doug. I've already got more queries than I'd like in this thing. I may try your suggestion on something else, though. So, I'm rating it acceptable.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 97 Macro Question 2
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")