Software

General discussion

Gravatar
Locked

Access 97 Macro Question 2

By learneverything ·
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.

3 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Access 97 Macro Question 2

by donq In reply to Access 97 Macro Question ...

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.

gravatar
Collapse -

Access 97 Macro Question 2

by learneverything In reply to Access 97 Macro Question ...

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.

gravatar
Collapse -

Access 97 Macro Question 2

by learneverything In reply to Access 97 Macro Question ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Start or search

Related Forums