View Single Post
  #2  
Old February 9th, 2010, 10:21 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Fill in a field based on input of data in another field

Tammy

I may be reading too much into your description ...

It sounds like your user is required to type in a [PermanentCountry] value
.... why?

If the database already possesses a tblAwardCountries, why not use a
combobox to list those and let the user select the correct one? And if it
is a new, never-been-entered Country, Access HELP has plenty of information
on using the LimitToList property and the NotInList event to handle adding a
new one.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Tammy" wrote in message
...
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!