hide items in drop down menus instead of deleting them

J

john mcmichael

Is it possible to simply hide an item from a combobox/ dropdown list instead
of deleting it from the list so I can use it later.

Thank you for help and support
 
K

KARL DEWEY

Add a field named Active that is a Yes/No field. Use a query as source for
the combobox with criteria to eliminate any non-active items.
 
X

xRoachx

This can be done but it requires that you add a field to the source table and
edit the row source for the combo box. This is easy to implement. Add a
column to the source table labeled Active. The values are Y and N for Active
and Inactive values (or A & I if you prefer). For the values you want
displayed, place a Y in the Active column and N in the Active column for
those you don't want displayed.

In the Row source property of the combo box, add a WHERE statement to the
SQL. The syntax is WHERE TableName.Active = "Y". For example, say your
table is named Widgets and you want to display the name of all Widgets in the
table. Your SQL in the row source property may look like the following:

SELECT WidgetName FROM Widgets WHERE Active = "Y" ORDER BY WidgetName
 
Top