I have a form with two combo boxes on it. The combo boxes are synchronised using a query so that when I select a value from combo 1, combo 2 is filtered.
My problem is that once Ive selected a value in both combo boxes and add a new record, both the combo boxes retain the values from the...