Access -data validation when entering into a table (KBV)

G

Guest

I created a simple drop down list from which users can select to enter data
into a table. However, it is still allowing a user to enter a value outside
of that drop down list. How can I prevent the user from entering values that
do not appear in the drop down menu?
 
A

Allen Browne

1. Set the Limit To List property of the combo to Yes.

2. Open the Relationships window (Tools menu), and create a relation between
this table and the one that holds the lookup values (the combo's RowSource).
In the Create Relationship dialog, check the box for Referential Integrity.
 

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

Access 2007 - Table A lookup values based on Table B 1
Automatically enter values in fields in a table 1
Automatic Refresh 2
validation rule to a combo box? 5
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Validation Question 1
dynamic range and data validation 3
Data Validation and Dynamic Ranges 2

Top