Autofill multiple text boxes from a List Box

[Chuck B]

I am brand new to Access 2003. I am creating a new form. On the form I have
a list box (for the Primary key) then 3 text boxes: one for LastName, Address
and Phone.
What I need the form to do:
When I select a record from a table in the List box, I need the 3 text boxes
to autofill the LastName, Address and Phone with the information of the same
record selcted in the List box.

I'm starting a new job and this information will help me build a database I
can use to save time with some massive data entry.

 

[John W. Vinson/MVP]

I am brand new to Access 2003. I am creating a new form. On the form I have
a list box (for the Primary key) then 3 text boxes: one for LastName, Address
and Phone.
What I need the form to do:
When I select a record from a table in the List box, I need the 3 text boxes
to autofill the LastName, Address and Phone with the information of the same
record selcted in the List box.

I'm starting a new job and this information will help me build a database I
can use to save time with some massive data entry.

Stop.

If you're trying to copy the Last Name, Address, and Phone information
from one table into another table, you're missing the point of how
relational databases *work*!

This information should exist in one table, and one table only. If you
need to reference a person in some other table, the second table
should contain ONLY a field for that person's unique ID.

You can *display* the information on your form, for instance by having
textboxes with a control source like

=listboxname.Column(n)

where n is the zero based index of the field you want to display. But
don't try to store that name in some other table!