How to clear search box after leaving the field? 1

[Guest_imported]

My main form that has a combobox that searches for records. When I search for one and then leave the combobox, the title I was searching for still remains in the combobox. I would like it to remove the title OnExit but I am not sure what command to use.

Why do I want to do this? When I go to do a second search (or a third or fourth, etc), I have to take the mouse and highlight the old search item before I can start typing in a new search item. Big pain in the butt.

I thought about the Undo command but if a title was entered and then another search was done, the undo will put the old title back in.

 

[raskew]

Make the last line of the combo-boxes AfterUpdate event something like:

Me!cboFindSomething = Null

 

[huzza]

Hi,
you could try putting the following in the on exit event of the combobox:

Me.Combo0.SetFocus
Me.Combo0.Text = ""

You'll have to change combo0 with the name given to your combobox.
Richard

 

[Guest_imported]

Thanks! That was the kind of stuff it needed!