S
Skeletor
I have a table called tblAppointments that, via command button on the
"Appointments form, sends an appointment to Outlook. The form; "Appointments"
is a subform on the "Customer Details Form and therefore creates new
record(s) for each customer when an appointment is made. The
"tbleAppointments has the following fields;
Appt- sends such as Customer Name and phone number info to Subject Line in
Outlook
ApptLocation - Sends Customer Address to Location in Outlook
ApptDate -
ApptTime
ApptLength
Notes- Sends copy of notes to Outlook
What I would like to do is autofill the "Appt", "ApptLocation" and "Notes"
fields on the subform from the "Customer Name", "Customer Ph", "Street
Address", "Suburb" and "Notes" fields on the parent "Customer Details" form
and store the information in the "tblAppointments" table for sending to
Outlook.
Coud someone please help!!!
Mike
"Appointments form, sends an appointment to Outlook. The form; "Appointments"
is a subform on the "Customer Details Form and therefore creates new
record(s) for each customer when an appointment is made. The
"tbleAppointments has the following fields;
Appt- sends such as Customer Name and phone number info to Subject Line in
Outlook
ApptLocation - Sends Customer Address to Location in Outlook
ApptDate -
ApptTime
ApptLength
Notes- Sends copy of notes to Outlook
What I would like to do is autofill the "Appt", "ApptLocation" and "Notes"
fields on the subform from the "Customer Name", "Customer Ph", "Street
Address", "Suburb" and "Notes" fields on the parent "Customer Details" form
and store the information in the "tblAppointments" table for sending to
Outlook.
Coud someone please help!!!
Mike