troubleshooting Question

MS Access 2003 cannot access Subform making me crazy

Avatar of Larry Brister
Larry BristerFlag for United States of America asked on
Microsoft AccessMicrosoft ApplicationsMicrosoft Development
13 Comments1 Solution629 ViewsLast Modified:
This makes no sense to me.

I have 5 forms
Top level form
    3 subforms
         1 subform on of the first midlevel subform

The following is the structure with the forms names as seen in the MS Access Forms window

ClientVisits
     MarketingVisitationClient
              MarketingVisitationClientContactsWorklist
     ClientVisitContactEvent
     ClientVisitsNearbyLV

There is a combobox on the top level ClientVisits form.
On the Combobox after update or change event I can access sub routines within all three mid level forms

Example...
 Me!MarketingVisitationClient.Form.loadRows
 Me!ClientVisitContactEvent.Form.loadQuestions  

But for the LIFE of me I cannot access the sub_sub form named:
MarketingVisitationClientContactsWorklist

I can't do it from
ClientVisits
Nor can I do it from
     MarketingVisitationClient

Where would be the best place to call the MarketingVisitationClient.Form.routinename and what syntax on the combobox change or update event?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 13 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros