I'm new to access so I thought this would be easier than it is. I have a list of cities in a simple table . I want use this list (or a query of it) to create a validation rule for a field in a second table "City". How, either with VBA or some other method do I use the Cities database to validate entry. These tables are both in the same project.

Any help is appreciated.

Personally I wouldn't bother with a validation rule. In any form dealing with the second table, I'd use a combo box that got its values from the first table, with its Limit to List property set to Yes, so the user could only choose from existing values.

Pbaldy,

Thanks for the quick reply. Thanks to your hint now I understand. As I said I'm new to access and created a set of databases and immediately thought about validation rules like I use for excel entry which are use the combo box approach (validation rule is built from a list). I quickly accomplished my need for a new entry with the combo box as you suggested. Now if I want to import data from outside acces into the table don't I still need a validation rule to qualify it? Also, if I already have a database, how can I get the combo box to use the current value for each record?