email conformation

[spoonman]

created some marco code... that i want it to create a pdf of a form and then email it. but the only problem is i cant figure out how to select the current record and not every record... i want it to be be like when you choose the selected record only when you print out or when you create a button like to another form that opens only that records infomation. kinda like the where condition when you open a form, report, table, query.



is it possible to create a where condition in vb or marco so that it only makes a pdf copy of the record current record?

'------------------------------------------------------------
' EMail_Confirmatin
'
'------------------------------------------------------------
Function EMail_Confirmatin()
On Error GoTo EMail_Confirmatin_Err

    DoCmd.SendObject acForm, "Email Confirmation", "PDFFormat(*.pdf)", "", "", "info@.............com", "Confirmation Email", "...............wants to thank you for.", True, ""


EMail_Confirmatin_Exit:
    Exit Function

EMail_Confirmatin_Err:
    MsgBox Error$
    Resume EMail_Confirmatin_Exit

End Function

[pbaldy]

Either open the report first in preview mode restricting it to the record:

http://www.baldyweb.com/wherecondition.htm

Or use this technique, which is probably what I would do to avoid the overhead of opening the report:

http://www.granite.ab.ca/access/emai...recipients.htm

[spoonman]

you gave me an idea from this material. thanks

[pbaldy]

No problem.