Validation Rule

N

nathan

I want to create a validation rule in a text box that says
the entered value can must be in a field of a table or
query.
 
K

Ken Snell

If you want to limit the user to just the values that are in a field in a
table, don't use a textbox control. Instead, use a combo box or list box
control -- both allow you to limit the choices to just the ones you will
accept, and you populate their lists via a query that selects the desired
values from the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing blank field 7
Validation rule for Combo Box 0
Multiple Validation Rules 1
Need to change NULL to Space in Form 7
Access Validation rule of 1 field based on a field of another table 1
Custom validation rule 4
Validation Text 1
How can I allow hyphen (or dash) in this validation rule? 1

Top