items in a combobox

[combobox via AccessMonster.com]

how can i disable items listed in a combobox?

i have this combox with items yellow, red and blue how can i disable the
items red and blue in a button click event

 

[Marshall Barton]

how can i disable items listed in a combobox?

i have this combox with items yellow, red and blue how can i disable the
items red and blue in a button click event

You can't disable them. The usuak thing to do is to filter
those values out of the combo box's row source so they don't
appear in the list.

If you really have to display the entire list, then you will
need to check for the values you want "disabled" In the
combo box's BeforeUpdate event:

If Me.combo = "red" Or Me.combo = "blue" then
Me.combo.Undo
Cancel = True
End If