Question Emailing a single record - URGENT !!!

[norton]

Hi all ... i know this has probably been dredged up before but I am struggling with this and I need an urgent fix.

I am trying to email a single record in a report. But no matter what I have tried it always produces a report of all recordests. I just need it to send the report that is currently being viewed in a form.

my current code works but only for 'all recordsets'.

here it is:
Private Sub sendMail_Click()
On Error GoTo Err_sendMail_Click
Dim strWhere As String
Dim stDocName As String
strWhere = "fldID"
stDocName = "rptPrintRecord"
DoCmd.SendObject acReport, stDocName, , "", , , "Website Enquiry", "Please find the attached Website Enquiry for your attention."

Exit_sendMail_Click:
Exit Sub
Err_sendMail_Click:
MsgBox Err.Description
Resume Exit_sendMail_Click
End Sub

any further help would be greatly appreciated.

 

[stopher]

One way is to set up the filter in the report (and switch it on!). You will want the filter to reference the field on your form. So the filter will look something like:

[myTableField]=forms!myFormName!myFormBoxName

Save the report (don't forget to switch the filter on). The report will then open for the record given in the form. Note that the report won't work if the form isn't open.

Your code will the run the report which will filter.
You can get rid of: strWhere = "fldID"

hth
Chris

 

[norton]

Hi Stopher,

Thanks for that , i'm a little confused what you mean by myFormBoxName ?

 

[norton]

Ignore that ... all working now MANY THANKS !!!

 

[stopher]

Hi Stopher,

Thanks for that , i'm a little confused what you mean by myFormBoxName ?

Sorry, myTextBoxName would have been better. Glad you got it working.

 

[Djurocar]

Hi guys, I don't know what to put in myFormBoxName/myTextBoxName field, I'm noob, please help!

Thanks!

 

[Djurocar]

Bump. This is urgent for me as well

 

[neileg]

Hi guys, I don't know what to put in myFormBoxName/myTextBoxName field, I'm noob, please help!

This should be the name of the control on the form that accepts the user input.

 

[Djurocar]

Thanks!

EDIT:

Hmm, now I seem to be getting just blank fields on the RTF.. would anyone mind if I sent them the mdb so they can put in the proper thing?

EDIT2:

Here it is, for anyone willing to take a look, please help!

http://rapidshare.com/files/138976439/IOCL-QS.mdb.html

 

[Djurocar]

Bump for those who haven't seen the 2 edits..