Thanks Nic,

Your trick worked. I created a new blank DB and copied all tables and forms from my corrupt DB and everything worked as expected. You've saved me from countless wasted hours :)

Cheers,

Hi,
I am very new to Access and have what I think is a fairly simple database and form. On my form I have one combo box that sets a filter for my second combo box. The filter works fine when I first select the value for ComboBoxA (ComboBoxb is filtered correctly). When I change my selection in ComboBoxA the list available for me to select from in ComboBox B does not change (it does not re-filter).

I have tried ...