items in a combobox

  • Thread starter Thread starter combobox via AccessMonster.com
  • Start date Start date
C

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
 
combobox said:
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
Click to expand...


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
 
Back
Top