Basing five combo boxes on one other combo box in an Access forms

[Guest]

I know how to base one combo box on another. I would like to know how to base
five combo boxes on one combo box and send that data to a table and/or a
report.

Example:
When I enter a SSN number in one combo box, I would like the following
columns to be populuated other combo boxes in a form
mailing name
five lines for mailing address
salutation name

Thank you very much, Bobbie Coats
215-895-2608
(e-mail address removed)

 

[John Vinson]

I know how to base one combo box on another. I would like to know how to base
five combo boxes on one combo box and send that data to a table and/or a
report.

Example:
When I enter a SSN number in one combo box, I would like the following
columns to be populuated other combo boxes in a form
mailing name
five lines for mailing address
salutation name

Why?

Storing data redundantly in another table wastes space, and - much
more importantly - risks having the same person with two different
addresses in two different tables.

Instead, simply base your Report on a Query joining the employee table
to your other table.

Remember, a Form doesn't contain any data; it's a tool to display data
in a Table. Similarly a combo box doesn't contain any data; it's a
tool to allow the user to select from a list. If you're filling in a
known value use a Textbox instead - you can set its Control Source to

=comboboxname.Column(n)

where (n) is the zero based index of the field in the combo named
comboboxname.

Thank you very much, Bobbie Coats
(xxx)xxx-xxxx
(e-mail address removed)

It is a VERY bad idea to post personally identifiable information,
particularly your email address, on these public newsgroups. They go
all over the world and spammers routinely "harvest" any email
addresses; and someone can look up your phone number in a reverse
directory. Please be more careful!!

John W. Vinson[MVP]