Validation rule with combo box

buddythebest

Registered User.
Local time
Today, 20:01
Joined
Mar 31, 2006
Messages
32
What validation rule could be used with a "Combo box" field so that only the data in the combo box is accepted.
 
If it's a form, go to the properties of the combo box, go to the Data tab and change the line that states "limit to list" to Yes. This should stop the user from inputing anything that doesn't exist in the combo box.

If it's a table, it's the last option for the specific field in design view.
 
thnx. I knew about the "limit to list" thing but i forgot that applying it in the table will not apply to existing forms from the table.
 

Users who are viewing this thread

Back
Top Bottom