Clear cbo and subforms

[Steven811]

Hi

I have constructed a form that consists of 4 cascading cbo boxes and 2 subforms. (Thanks to mile o phile)

When I have made my final selection in the last combo and go back and choose another record from the first combo I requery the second combo, this leaves the records in the other combo boxes and subforms.

How do I alter my code to requery the combo boxes and subforms so that they clear and can not be edited.

Steven811

 

[pat_nospam]

Me.ComboBox.Requery should do the trick. Just post that in the On_Enter or After_Update feature of your first combo box (or all of them).

Hope this helps - Pat