autopopulate field in subform from field in main form

  • Thread starter Thread starter Skeletor
  • Start date Start date
S

Skeletor

I have a Customer Details Form bound to a "Customer Details" Table. I also
have an "Appointments" subform attached to it that is bound to the
"Appointments" table.

I would like to auto-populate the "Appt" field on the subform with data from
the "Name" and "Phone Number" fields. I would also like to auto-populate the
"Location" field on the subform with data from the "Address", "Suburb" and
"State" fields from the main form.

How do I do this so that the underlying "Appointments table" can store the
information from the subforms fields?
Thankyou in advance
Mike
 
Thankyou for your help. The "Appointments" table is used to send the
appointment to Outlook. Or can this be acheived another way? If so. How?
Best Wishes
Mike
 
Thankyou for your help. The "Appointments" table is used to send the
appointment to Outlook. Or can this be acheived another way? If so. How?
Click to expand...

Yes; use a Query joining the appointments table to the employee table, and use
that Query for the transfer to Excel. It's not necessary to use a Table.
 
It's Working!!!!! Thankyou to John and DStegon.

John W. Vinson said:
Yes; use a Query joining the appointments table to the employee table, and use
that Query for the transfer to Excel. It's not necessary to use a Table.
Click to expand...
 
Back
Top