Making a blank selection in combo box

[OrganMan]

I have a eight combo boxes that are bound to a look up table. How can I give the user the ability to make a blank selection or change their selection from a valid selection to blank in case their selection was made in error.

eg

cboStaffing has one of 10 different shifts to choose from in the drop down, if the user selects one of the shifts in error and there should have been no shift chosen, how can the user de-select the shift or select a blank shift? I have seen drop downs with a blank at the top of the combo list that can be chosen, just not sure how to code for it.

Thanks for the help.

 

[Kempes]

you could add a button to clear the contents of the box using vb code, and refreshing the form.

eg,

me.combobox1.value = ""
me.refresh
me.requery

 

[DCrake]

Simple Software Solutions

IF you are using a value list then make the first option ""

if you are using a bound query/ table add a blank entry to your source table with 0 id

 

[OrganMan]

Thanks DCrake, I added a blank entry to the tabe with ID of 0, works good