Software

Ask something
Discussion Locked

Access 97 Macro Question 2

0 helpful
3 replies

by learneverything

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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")

3 replies

by donq

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.

by learneverything

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.

This discussion is closed to new replies.