MS Access 2003 call form from anywhere

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
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
hnasrConnect With a Mentor Commented:
Assume frm has subfrm and the control ctl on that subform.
To access ctl:

Forms!rm!subfrm!ctl

Forms!MarketingVisitationClientContactsWorklist!SubFormControlWithinform!controlOnSubForm
0
 
Anthony BerenguelCommented:
Public sub name_of_your_sub()

    Your code

End Sub

Then call name_of_your_sub within the clock event of your buttons.
0
 
Anthony BerenguelCommented:
Clock is supposed to be click
0
 
Larry Bristersr. DeveloperAuthor Commented:
thnks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here