Using a table to validate a form

P

Paul CTMIC

Access 2003,
I have a form with "plan code" as one of the entry fields. To go along with
that form I have a table with acceptable "plan codes". How can I check what
the user enters againest the acceptable table without having to type all the
acceptable codes into the validation rule?
TIA,
Paul
 
M

mscertified

Why not have a combo box populated from the table and set 'restrict to list'
property to YES. That way there is no need to do any validation at all. The
user is only able to enter a value from the table. This is the best way to do
all data entry since it totally avoids the whole problem of validation.

Dorian
 
J

Jeff Boyce

Paul

Use a combo box on the form. Make the row source the table of valid codes
(a "lookup table").

Bind the combo box in the form to your 'plan code' field in your main table.

Regards

Jeff Boyce
<Access MVP>
 
Top