Access lookup function based on a field value
Posted on 2009-02-19
I am a very very very novice Access user. I have a simple database with one form and two tables. It stores contract information for a limo rental company. What I am trying to do is get Access to populate the address and city fields on the form based on what the user enters in the location field.
My location table has all the names and address info for wedding and banquet halls. When a user fills out the contract form and types in "White Cliffs" in the location field, I want Access to do a lookup to the location table, find White Cliffs, and grab the address, city, etc and populate the associated fields on the contract form, thereby saving key strokes for the user filling out the form/contract.
I hope this makes sense.
Thanks much Experts. Remember, I am a newbie...:-)