1. Version of the program:
Access 2010
2. What I want it to do:
On the single click of a button in a form, I would like it to add the new record and send the record in an email to adynamic email address taken from an input in the form.
3. The Data:
The table the form is built from is:
Assignment
The field names are:
User IDFK (Email Address)Project IDFKTask IDFKAssignent Date (Not listed in the form)
5. The Current Code:
Private Sub CreateProjectButton_Click()DoCmd.GoToRecordEnd Sub