How can i fill address fields with data from another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Read Only" Query 0
Automatically enter values in fields in a table 1
field value concatenation VBA 1
contact address and/or billing address 4
How can I eliminate blank rows in record on a form? 12
Access Automatically Send a notification email once a record is added 0
primary key - concatenated or autonumber? 6
DELETE FROM a table WHERE... 1

Back
Top