Auto-fill with related fields?

[LinearChaos]

Is it possible to connect data so that when one field of a record is entered the rest of the fields associated with that first field of the record automatically fill in?

Example: If I were to enter a new contact record name in the name field I want the corresponding fields of address, city, state, zip, phone....etc. to fill in automatically.

 

[Boo]

First make sure you understand autolookup queries.

If that is not the answer,

Read up on DLookup function.

Access help has good info on both.

 

[LinearChaos]

Awesome, I think I'm almost on the right track...

If I set up an auto lookup querie and use the Dlookup function in the criteria space on the querie grid then it should work...theoretically.

I'll try it and let you guys know!

 

[ansentry]

Have a look at my attachment to this post:

http://www.access-programmers.co.uk/forums/showthread.php?t=102245

 

[LinearChaos]

Have a look at my attachment to this post:

http://www.access-programmers.co.uk/forums/showthread.php?t=102245

Thanks but that's not what I'm trying to accomplish. I'm not using a combo or list box in any way.