Show Blank in Combo After Selection for Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am using an unbound combo to search records on the main form. When I
first open the form from design view, the combo is nicely set to blank until
the user clicks it (and can select record to find in the list.) After the
record has been selected and appears in the main form, how can I remove the
name of the field from the combo so it's blank again, ready for the next
search, rather than still displaying the name of the record it has just
found? I need to do this so that the user can click in the combo if they
want (rather than selecting from the list by using the down arrow) and enter
the first few characters of what they're searching for without having to
delete the contents of the previous search first.

TIA!

Rich
 
Hi Rich,

Thanks to other people in this forum I was able to achieve the exact same
thing as you require,,.

In the 'On Got Focus' event procedure of the combobox in question add this,
change Combo10 as appropiate.

Private Sub Combo10_GotFocus()
Me.Combo10.Value = ""
End Sub
 
Back
Top