I know another Combo Box Question

[alguzman]

I have two combo boxes. One has membertypes and the other has submembertypes. I have it so that when I click on the membertypes combobox the second combobox displays only the submembertypes that belong to the membertype that was selected in the first combobox. Waht I'm now trying to do is if someone enters a new memberype into the first combobox the submembertype in the second combobox clears out and is ready to be updated to the new submembertype from the first combo box. I hope you understand that. Any help would be great. Al

 

[AlanS]

In the OnUpdate event procedure of Combo1, put the following code:

Combo2.Requery

and make sure that Combo2 has no default value, which will force your users to either select one or leave it null after each change made to Combo1.