generating a report in VBA

V

velmj

HI all,
I have a "Inspection" report in my database. Whenever the user fills out
a form, I want to take the values in the form and create the report and email
it to the user. Right now, the report has a query as its record source,
which takes 3 arguements (primary keys).

The following didnt work.

Dim rpQuery as string
rpQuery = "Select * from 2003 where ...."
DoCmd.OpenReport "Inspection", acViewPreview, rpQuery
DoCmd.save acReport, "Inspection"

DoCmd.SendObject acSendReport, "Inspection", acFormatHTML, "[email protected]",...


I am getting an email but there is no data in the report.
Any body guide me how to do it?

Thanks,
Vel.
 
Top