I have a form that contains a combobox containing a list of departments.
When a department is selected I would like a listbox to display info. from a db table that belongs to the dept selected.
Here is the Row Source for the listbox.
SELECT NRN FROM tblRegion WHERE Depts =[Forms]![Form1]![ComboDebts];
When the form first loads the list box contains the info. relating to the combobox selected Dept. What I would like is when a new dept. is selected in the combobox the list box refreshes the data.
At the moment nothing happens unless I refresh the form from the refresh button on the home ribbon.