Clear the info displayed after selection in an unbound combo box

[clmarks]

I am working on an employee information database in Access 2003. I have a combo box at the top of my form which is used to select which employee to display. After the selection has been made, I want the combo box to return to being blank (like it is when I first open the form). Currently, the last name that was selected remains in the combo box. It is confusing to my end-users when the combo box says one thing, but they are looking at a different master record. This situation occurs when they use the navigation buttons to move through master records or when they have added a new master record, etc.

Will someone please point me in the right direction?

Thanks,

Cherry

 

[John Big Booty]

Use Me.ComboName.Value = Null in your code to set the Combo to blank.

 

[pbaldy]

This type of thing should work:

Me.ComboName = Null

 

[clmarks]

It worked like magic!

Thanks for the help.