I am creating a database to store Diagnosis of patients. I have created two synchronized combo boxes so that when you choose a main category from the first one, a query runs and displays in the second box all of the subcategory's of the category you chose. This works fine. The problem is that no matter what subcategory I choose in the second combo box, it defaults to the first one in the list. I am on a deadline, and this is the last step to my database being complete. Please if anyone has any ideas please post them. Your help is much appreciated.

Does the second combo box contain a default value in its properties?

No there is nothing in the Default value of the properties list.

Would adding a button linked to a macro that resets the combo box 'on-click' work?