Solved

MS Access 2003 call form from anywhere

Posted on 2012-12-27
4
340 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

773 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