Help creating a process on a form

mjwillyone

Registered User.
Local time
Today, 09:56
Joined
Aug 3, 2004
Messages
27
Friends,

I have an Access database which I am working on that will keep track of employee insurance contacts we make to them/on their behalf.

I am attepting to automate the procedure of sending dependent student certifications forms to these employees by e-mail and recording this step as having been done.

Here is what I have:
The main form: StaffInfo
The sub form: ChldSubForm

Here is what I want to be able to do:

1. select a child from the subform (select the whole record??)
2. click a button (or something) that begins the process of sending the information to a MSWord Document (Name of employee from the form, name of child, etc. from the sub-form)
3. have another table set up so that information on the child, college, date, and user are placed so that we have a record that we processessed this form. This table should be linked so that we can view it on the employee's (parent's) form.

I know I am asking alot ... but I am lost when doing this.

Thanks,
Mike
 
Last edited:

Users who are viewing this thread

Back
Top Bottom