Solved

MS Access 2003 call form from anywhere

Posted on 2012-12-27
4
342 Views
Last Modified: 2012-12-28
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
Comment
Question by:lrbrister
  • 2
4 Comments
 
LVL 10

Expert Comment

by:Anthony Berenguel
ID: 38725387
Public sub name_of_your_sub()

    Your code

End Sub

Then call name_of_your_sub within the clock event of your buttons.
0
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 38725499
Assume frm has subfrm and the control ctl on that subform.
To access ctl:

Forms!rm!subfrm!ctl

Forms!MarketingVisitationClientContactsWorklist!SubFormControlWithinform!controlOnSubForm
0
 
LVL 10

Expert Comment

by:Anthony Berenguel
ID: 38725578
Clock is supposed to be click
0
 

Author Closing Comment

by:lrbrister
ID: 38726977
thnks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question