send object using a maco--filter report

  • Thread starter Thread starter Karen
  • Start date Start date
K

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?
 
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.
 
Back
Top