• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

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
0
lrbrister
Asked:
lrbrister
  • 2
1 Solution
 
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
 
hnasrCommented:
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:
Clock is supposed to be click
0
 
lrbristerAuthor Commented:
thnks
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now