Two comboboxes don't affect each other

[tomas_s]

In my database you can search on either number or name. I have therefor, two combo boxes. and it works well, except that...

when I pick by number first, and then try to pick another record using the name combobox, the number combobox still shows the first search I did. I would like the two comboboxes to interact with each other, do you know what I mean?

 

[John Big Booty]

If you mean you want one of Combo Boxes to change to blank when the other changes, then you could use some code in the After Update event of each combo, along the lines of;

Me.OtherComboName = ""

 

[tomas_s]

oh cool, yeah I will try that.