Set Combo Box to Blank

[CK]

I have an option group with 2 option buttons. When I click on option 1, combo
box1 will be enabled and combo box2 will be disabled. When I click on option
2, combox box2 will be enabled and combo box1 will be disabled. This works
fine but the problem is that after making a selection in any of the combo
boxes and then disabling it, I can still see the previous selection except
that it is being greyed off. HOw do I get the combox box to be totally blank
like when the form was first opend? I tried with the combobox.rowsource = ""
but still no effect.
ck

 

[Arvin Meyer]

Depending upon the data, but usually:

me.combobox = ""

if that doesn't work:

me.combobox = Null

You don't need to change the rowsource property, you need to change the
..Value property. The default property of a combobox is the .Value property,
so this also works:

me.combobox.value = ""
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access