Help me please! I am Desperate!

[newberc]

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.

 

[Robert Dunstan]

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

 

[newberc]

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

 

[Maryanne]

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