Select from a Column when sending an appoint to Outlook frm Access

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
 

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

Top