MS Access 2003 call form from anywhere

Larry Brister
Larry Brister used Ask the Experts™
on
Lets say I have 20 forms in my MS Access 2003 adp application.

What VBA would I use to access a control on a particular sub-subform from a button click on ANY other form?

The Forms name is MarketingVisitationClientContactsWorklist
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Anthony Berenguel

Commented:
Public sub name_of_your_sub()

    Your code

End Sub

Then call name_of_your_sub within the clock event of your buttons.
Retired IT Professional
Commented:
Assume frm has subfrm and the control ctl on that subform.
To access ctl:

Forms!rm!subfrm!ctl

Forms!MarketingVisitationClientContactsWorklist!SubFormControlWithinform!controlOnSubForm
Anthony Berenguel

Commented:
Clock is supposed to be click
Larry Bristersr. Developer

Author

Commented:
thnks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial