How to use criteria when attaching a snapshot to an email? 1

[snowyej]

Me again...

In my form I have a button users can click to email a set group of people when a record has been updated. I would like to attach a snapshot file of the report based from this form (or table). However, when I attach the snapshot, it shows all the records in the table. I would like for it to just show the record that was updated. How can I do this? My "doCmd" is:

DoCmd.SendObject acSendReport, "rptIssues", "Snapshot Format (*.snp)", EmailRecipients, , , subject, bodytext, True

I'm sure I need additional code to set the criteria but I'm not sure what.

Thanks in advance!
Elizabeth

 

[outpatient]

Hello....again,

In your query that is generating the report modify the criteria to be the control on the form which contains the record number. So you would enter somthing like:

Forms!MyForm.RecordNumber

When the query runs, it pulls your record number and should just produce that one. Sam Greene
anyone in need of a rock induced headache? if so

http://www.mp3.com/outpatient

 

[snowyej]

Sam,

That worked great! Thanks so much!!

Elizabeth