clear a combo box search field

D

Denise

Aafter I select a name from the list it searches and brings up that persons
record. What do I need to put in the (event or macro) to clear the field
after it finds the person?

Thanks.
 
J

Jeanette Cunningham

Something like

Me.[NameOfCombo] = Null


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
F

fredg

Aafter I select a name from the list it searches and brings up that persons
record. What do I need to put in the (event or macro) to clear the field
after it finds the person?

Thanks.
Click to expand...

In the same event that you use to bring up that selected record add,
after the code to find the record:
Me.ComboName = Null
 
Top