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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

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

Automatically enter values in fields in a table 1
Access 2007 - Table A lookup values based on Table B 1
How to Populate Data from a table to another 0
Should this be two tables? 2
Date/Time to Display only Month 7
Combo Box to enter data to text box! 15
I want to enter new data into a lookup field... 1
cboselection box-can I use it to enter data? 3

Back
Top