block an item in combo box

[Guest]

I have a combo box call equipment, it is a drop down box with a list of
equipments. one participlar item we no longer using it. I do not want to take
it out because it have vital infomation. therefore how can i put a code to
gray that item/area so no one can select it.

Thanks
Bessie

 

[Al Campagna]

Bessie,
There's no way I know of to "grey" out a combo selection. It needs to be removed from
the query behind the combo.
The most straight forward way would be to add an True/False field to your Equipment
table called [InActive]. Make it a checkbox on your Equipment form, and if that box is
not checked (False), the item is considered Active (the default). If checked, (True) then
it's "Inactive".
Now your combo query can filter out all InActive = True items.
Later if you want that item added back into the list, just uncheck that record.