Empty combo box - 'none' option

[fraser_lindsay]

Does anybody know how to add an option that says 'none' or 'no selection' or something to a list of combo options.

I use a query by form to produce a report. But I may close that report and it goes back to the form. If I want to re-run a new query I have to close the form and re-opne it so the combos are empty.

Is there anyway to have a 'none' option to empty the combo box?

 

[MStef]

You don't need "none", if you want empty combo put DblClick event on combo and VBA.

Me.ComboName = ""

 

[fraser_lindsay]

Thank you, that's exactly what I need.

Much appreciated, it was getting quite annoying.