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?
ASKER CERTIFIED SOLUTION
ErezMor

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