Validation Question

[Guest]

I'm using V2002 (XP).

I'm importing some data from Excel into a table.

I have a title field set up as a combo box containing values like Mr, Mrs,
Dr etc. I have the lookup field property limit to list set to yes.

When I import the data from Excel, some of the records contain 'Miss'. Miss
doesn't appear in my drop down list of titles. I Excel to tell me when I do
the import that I cannot import those records because that value isn't in the
drop down list. I think I need a validation rule - can anyone tell me the
correct syntax / expression to use to check this?

Thanks

Anita

 

[Jeff Boyce]

Anita

If you'll check the "tablesdbdesign" newsgroup (and mvps.org/access), you
find that there's a strong consensus against using the lookup datatype in
table definitions. One reason (and I suspect the reason you may be seeing)
for this is that Access stores one value in the field, but displays a
different value (i.e., the "looked-up" value. This can be confusing.

The recommendation is to do your lookup (i.e., using combo boxes) in your
forms, not your tables.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/