Button Click to clear entered text in a combo box

[weircolin]

Hi

I have a combo box on a form that is used to do a surname search. One
of the things the people using the database do is before adding a
person's details onto the database they persform a surname search. If
there is no match at all for the surname entered Access says so. If
clicking to enter a new record it still comes up with the same message
that there is no match for the name. This stops when deleting the
entered text into the search field.

I would like to make things easier for people so that they could click
a button to clear this field. If there anyway I could do this? If so,
how would I structute the code.

Cheers

Colin

 

[Ken Snell \(MVP\)]

Private Sub ButtonName_Click()
Me.ComboBoxName.Value = Null
End Sub