With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf
Solved
MS Access 2003 call form from anywhere
Posted on 2012-12-27
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 MarketingVisitationClientC
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 MarketingVisitationClientC
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
4 Comments
Public sub name_of_your_sub()
Your code
End Sub
Then call name_of_your_sub within the clock event of your buttons.
Your code
End Sub
Then call name_of_your_sub within the clock event of your buttons.
Active today
Assume frm has subfrm and the control ctl on that subform.
To access ctl:
Forms!rm!subfrm!ctl
Forms!MarketingVisitationC
To access ctl:
Forms!rm!subfrm!ctl
Forms!MarketingVisitationC
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month7 days, 4 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.