If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill in a field based on input of data in another field
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! |
Thread Tools | |
Display Modes | |
|
|