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.