How to make a limited combobox?

ariansman

Registered User.
Local time
Today, 12:42
Joined
Apr 3, 2012
Messages
157
There is a combobox on a form which enables us to select items from a field in a table ( for example Field: color, in the Table car-details). Color record examples: red, yellow, green, black, gray.
How can we limit the mentioned combobx to select fewer records of that field? For example red and gray.
Thank you,
 
If you want only red and gray as your options you will need to edit the table that is referenced in the combo box.
 
I can't tell if this is a real example so I'm not sure what the best solution would be. If you are trying to exclude "inactive" options, add a column to the underling table and use that to exclude some items in the query you use as the RowSource for the combo.

In any case, the RowSource will need to be a query and it will need selection criteria to select only the desired records.
 

Users who are viewing this thread

Back
Top Bottom