Import info from form to subform if null

  • Thread starter Thread starter jwr
  • Start date Start date
J

jwr

I have a form for customers and an issuing office form which is linked via
customerID. If the issuing office information is the same as the customer
information, Or if no information is entered on the issuing office form,
then I would like for the customer information (main form), name, address,
etc. to be imported into the issuing office fields.

Any suggestions? Thank you
 
jwr said:
I have a form for customers and an issuing office form which is linked via
customerID. If the issuing office information is the same as the customer
information, Or if no information is entered on the issuing office form,
then I would like for the customer information (main form), name, address,
etc. to be imported into the issuing office fields.

Any suggestions? Thank you

just use an append query and use the main form's PK as the foreign key
in the subform.
 

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

Back
Top