troubleshooting Question

Re-query a list box in a sub form when I select a different value from a list box in the main form.

Avatar of Richard Comito
Richard ComitoFlag for United States of America asked on
Microsoft AccessVB Script
13 Comments3 Solutions375 ViewsLast Modified:
I have a form that is t_name and in this form I have a List box.  When I select a value in the list box I have the results come up in a subform called t_address_subform, in the subform I have a different list box that pulls from a query design view.  I was just working on making sure that the subform list box pulled only the information on a specific name_id.  With help from EE this is now working when I load the form the first time.  But when I try and select a value from the list box in the t_name form the subform list box does not change.  I have tried to do a Click event with the list box in the main form that would make the subform list box requery.  But when I try to find the list box in the me.t_address_subform, I cannot find the list box.

My goal is to update this subform list box every time I make a new selection from the main form list box.

Should I be trying to use an event that is on the subform or is there a better way to do this?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 13 Comments.
Start Free Trial
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 3 Answers 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