How can I use a lookup field to fill in multiple fields?

[SharonC]

I want to use a lookup field in a form in order to automatically fill in
information such as address and phone number, using Name as the lookup field.
Can this be done in Access XP and how?

 

['69 Camaro]

Hi, Sharon.

It depends upon how you've designed your database and how you want to design
your form, but your description sounds like you need to "autofill" the form,
based upon records already stored in tables. For the steps on how to do
this, please see the tutorial on "How to 'auto-complete' a form, with and
without code" by using an auto-query to automatically fill in information
for new records:

http://www.Access.QBuilt.com/html/forms.html#AutoCompleteForm

For another idea on how to "autofill" the form with a complete record, see
Tom Wickerath's easy, step-by-step tutorial on finding a record using a
combo box on this Web page:

http://www.Access.QBuilt.com/html/find_a_record.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[SharonC]

Thank you. That is exactly what I was looking for.

Sharon

 

['69 Camaro]

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)