Email a Single Record

[NLR]

Hello. I've created a button on my ACCESS 2010 form that will send a PDF via email. However I only need to send the single record displayed on the form not all records.
The on click command of the button sends the PDF of the report. (I read that this is what should be sent; but still get the same results.)
I don't understand how and where to attach VBA code:
Me.Filter = "RequestsID=" & Forms![OD Reversal Requests]![RequestsID]
Me.FilterOn = True


I don't have any experience with VB code and am very confused as to how to go about this.
Thanks, any help is greatly appreciated!!

 

[pbaldy]

From the sound of it, that's code that would go in the open event of the report:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

 

[NLR]

Hi,
I'm sorry but I cannot access that site (controlled/limited access to some websites). Would you be able to send an attachment with the info?

Thanks!
NLR

 

[pbaldy]

I already mentioned where it would go, but the relevant part from the link:

Therefore you must change the filter or where clause yourself in the reports OnOpen event.

Me.Filter = "ShipmentsID=" & Forms![Select Load List]![LoadID]
Me.FilterOn = True

 

[NLR]

Hi,
Thank you!! That did the trick.

NLR

 

[pbaldy]

No problemo.