How can i fill address fields with data from another table

D

Draco

Having found a record with the address that i want, in the sub-form, how can
i copy the address data to the address fields of the current record in the
customer form ?
 
J

John Vinson

Having found a record with the address that i want, in the sub-form, how can
i copy the address data to the address fields of the current record in the
customer form ?
Click to expand...

Ordinarily you would not *want* to do so.

Storing data redundantly in two different tables is essentially NEVER
appropriate. Could you explain what tables the form and subform
display, and why you have the same address stored in two different
tables?

John W. Vinson[MVP]
 
Top