I am trying to learn a bit about Access and I am running into a problem. I have a form that has two drop-down boxes (category/subcategory).
Based on what is selected in the category drop-down will determine what is available in the subcategory drop-down.
That portion is working fine. However, if I decide to change whatever the initial value of the category field is, the old subcategory value is still displayed until I select a new record from the subcategory drop-down.
I am looking for a way to have the subcategory automatically clear itself out as soon as a selection is made on the category field.