send object using a maco--filter report

[Karen]

Hi,

I would like to use a macro to send a report as an email attachment . I
would like the user to be able to click a button on a form and send a report
that pertains to that record only. I have created a macro which will send the
entire report. Is it possible to program the condition column in the macro
wizard to point to only the record I am on? What would this look like?

 

[Steve Schapel]

Karen,

No, the Condition for the macro is not applicable. The Condition is a way
of determining whether or not the macro proceeds, whereas what you want is
to control which data is included.

Therefore, what you need to do is use a Criteria in the query that your
report is based on, referring to the identifying field on your form, using
syntax like this:
[Forms]![NameOfYourForm]![YourIDField]
Thus the report will only include the record related to the current record
on the form.