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.
 
Back
Top