updating form with information from table

[billyw]

hi..

currently have 2 tables.
1 with names and addresses called customers and another with some other
details that are changeable.
opening a form ican add al this info. the customer one being in the form of
a drop down list.
how would i go about setting it such that when i selected the customer name
in the drop down list in form then the address for that particular name
would be inserted in the address field also.

thanks

 

[John Vinson]

hi..

currently have 2 tables.
1 with names and addresses called customers and another with some other
details that are changeable.
opening a form ican add al this info. the customer one being in the form of
a drop down list.
how would i go about setting it such that when i selected the customer name
in the drop down list in form then the address for that particular name
would be inserted in the address field also.

thanks

You should NOT be storing the address redundantly in the second table
unless (and this is a very narrow exception) you WANT the customer to
have a "real" address and a "variable" address, which could be
different. Otherwise you're just wasting space.

If you just want to display the address, without storing it in the
second table, put a textbox on the form and set its Control Source to

=comboboxname.Column(n)

using the name of the combo box, and using the position of the address
field in the combo's row source query as (n). It's zero based so (2)
would be the third column in the query.

John W. Vinson[MVP]