We help IT Professionals succeed at work.
Get Started

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

374 Views
Last Modified: 2012-05-11
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?
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 3 Answers and 13 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE