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.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top