clear a combo box search field

  • Thread starter Thread starter Denise
  • Start date Start date
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.
 
Something like

Me.[NameOfCombo] = Null


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
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
 
Back
Top