Email a report for a individual record

B

Barry Phillips

I am working on a database to handle incoming Leads for our company. I have
a report set up to for new leads which need to be sent to a salesmen. What I
need to do is have the report only send the report for the record which is
shown on the form at that time by primary key field name [process number].
(not all records) which is what it is currently doing.

Any help would be greatly appreciated.
 
B

Barry Phillips

I have also tried using the following statement in the "email button" code,
but am not having success. If anyone can point me in the right direction it
would be a great help.

![frm dealer lead process].[process number]

frm dealer lead process being the form name and process number being the
field I want to match for the report.
 
Top