how to email current record show in form as pdf copy of the report

[sspreyer]

hi to all you access gods



i'm trying to email current record show on form by command button "Form name is new job" and i would like it to converts the report "report name is asset details" in to pdf attachment to email have issues how to filter it to current record show only the field guess you would filter it by will be the primary key " primary key field name is ID"

thanks in advance

shane

[pbaldy]

One way is to open the report in Preview mode filtered using this:

BaldyWeb wherecondition

then use SendObject to send the report, then close it.

[sspreyer]

hi

thanks but i still can't manage to get this to work how would i lay this out using macro builder sorrry my knowledge is great i dont no how to lay the code out basically

cheers shane

[pbaldy]

What I posted is VBA code, not a macro. If you want to use a macro, you'd use OpenReport with a wherecondition, SendObject, then Close to close the report.

[sspreyer]

hi
thanks for your help what would i put as the where conditon field ?

yet again thanks for your time

shane

[sspreyer]

thanks for your help after abit of fiding i have done it cheers

[pbaldy]

Happy to help!