I have a form that displays several fields from a table (Equip Info). On that form is also a subform that displays a list of data from a query (qry_Locations). The data from the query is from a separate table. Both tables have a field (“IDNo”) that should link everything together. I placed a list box on the main form that has the “IDNo” list (linked from the table “Equip Info”). When I click the dropdown arrow on the list box and select a different “IDNo”, the fields on the form and the data in the subform should all change to match the what’s in the two tables all on the same form. I had it working at one point, but something got corrupted in my database and I had to revert to an earlier version that does not have a working list box. Right now, I cannot get the list box to work again. When I select a different Equip ID, the subform data will change, but the main form fields do not. Please help.
