Clearing combo boxes

[Paul]

I have four unbound combo boxes that I want to use to
search for records. What I would like to do is when one
combo box is updated, the others are cleared so the search
is only based on the one combo box.

Any help would be greatly appreciated.

Cheers

 

[Van T. Dinh]

Try using the ComboBox_AfterUpdate Event to change the other ComboBox with
something like:

Me.OtherComboBox1 = Null

 

[Paul]

Sorry, should have said that I tried that. Doesn't work.

 

[Van T. Dinh]

Try setting them to empty String "".

 

[Paul]

Thanks! That works.

-----Original Message-----
Try setting them to empty String "".

--
HTH
Van T. Dinh
MVP (Access)





.