Want to chose from a list-then have the associated info fall into fields

[denilynn]

I want to be able to chose an entry from a drop-down list
in a form, and then have the related information
automatically fall into the appropriate fields. Example:
By chosing a last name from a drop-down list, the first
name, address, and telephone # for that client would
automatically feed into their respective fields on the
form.

Thanks!

 

[Van T. Dinh]

You can use the ComboBox Wizard to do this. In the first Dialog of the
Wizard, select the 3rd option "Find a record on my form based on the value I
selected in the combo box".

 

[John Vinson]

I want to be able to chose an entry from a drop-down list
in a form, and then have the related information
automatically fall into the appropriate fields. Example:
By chosing a last name from a drop-down list, the first
name, address, and telephone # for that client would
automatically feed into their respective fields on the
form.

If you're trying to store the name, address and phone for a client
redundantly in a second table (using this form)... DON'T. Store that
information once, and once only, in the client table, and nowhere
else!

In order to *display* the additional client information on your form,
one easy way is to use a Combo Box (the proper name for a "drop down
list") on the form, based on a Query containing all the fields that
you want to see. Elsewhere on the form you can put textboxes with
control source properties like

=cboClient.Column(n)

where cboClient is the name of the combo box, and (n) is the *zero
based* subscript of the field. For example, if Phone is the fourth
field in the combo box's row source query, use Column(3).

 

[Guest]

Thank you!

-----Original Message-----
You can use the ComboBox Wizard to do this. In the first Dialog of the
Wizard, select the 3rd option "Find a record on my form based on the value I
selected in the combo box".

--
HTH
Van T. Dinh
MVP (Access)






.