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

  • Thread starter Thread starter denilynn
  • Start date Start date
D

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!
 
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".
 
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.
Click to expand...

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).
 
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)






.
Click to expand...
 
Back
Top