Add record and send email on same click of button in form in Access

[NoGoodAtCode]

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 IDFK

Task IDFK

Assignent Date (Not listed in the form)

5. The Current Code:

Private Sub CreateProjectButton_Click()

DoCmd.GoToRecord

End Sub

[June7]

Sending email is common topic in forum. Two methods:

1. SendObject

2. open an email object and manipulate

Search on those keywords. Lots of examples. Here's one to get you started https://www.accessforums.net/program...ook-21903.html