autopopulate field in subform from field in main form

[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

 

[Skeletor]

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

 

[John W. Vinson]

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?

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.

 

[Skeletor]

It's Working!!!!! Thankyou to John and DStegon.

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.