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

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