Hi,

I'd like to know if this can be done without VBA, since I'm not familiar
with programming....Access 2007

My user has a table that contains countries: [tblAwardCountries]. When she
enters a value in her [PermanentCountry] field, she would like the database
to check to see if that country exists in [tblAwardCountries]. If it does
exist, she would like another field to automatically update to "Eligible for
Award".

Can this be done without programming? I thought of the IN operator, but
there are too many countries to have to type into the expression. Using a
table will be easier to keep updated.

Thanks for any suggestions!