send object with data

[mikeasa]

I am trying to automate sending the form out in an email with the data. I created a macro to send form but it does not populate the fields with the data. Can some one help me with this.

 

[Shirley]

Did you create a report of the form?

 

[mikeasa]

no I dont know how to do that

 

[Shirley]

It will be easier to email a report as an attachmet then to send the form. If each record as a primary key(ID) you can set it up where you will attach only the report pertaining to the form.

Creating a Report
1) Click on Reports/New/Report Wizard
2) select the query you are using for the from then click OK
3) Select the fields that you want to appear on the report.
4) Group the data by selection a field (yes or no)
5) Sort the data by a particular fields (yes or no)
6) Arrange the field to you specification.

Here is the VB that will help to narrow down the reports on the form.

DoCmd.OpenReport stDocName, acPrint, , "[ID]=" & [ID]