I currently have a listbox called "listbox45". Listbox45 shows all the records on my form called "main events form". Main events form has a subform within it called "event days table form". Event days table form has a listbox called listbox15. Listbox15 shows all the records on event days table form. I've attached a pic below of the overall form for better reference.
So now when I click on an item in Listbox45 it brings up another event. However, event days table form still shows the days from the previous record. What I would like is for listbox15 to update itself when I click on an item in listbox45. I tried the following code line:
me.event_days_table_form.listbox15.requery
Unfortunately I get an error message saying "item not found" or something along those lines. When I try to use autofill in the code window it won't show me listbox15. Is there some way to get listbox15 to refresh when I click on listbox45?
Many thanks for any assistance.