Filter before SendObject

[InspectorJoe]

I need to send a report, but only for the current record on screen. How can I filter/query using SendObject to email a report in snapshot format for only that record?

 

[Zeroanarchy]

The best way to do this is to have a button on your form that will automaticky print the report.

Now at the report end do as follows:
Goto Report Properties
Goto Record Source
and then select the ...
This will take you into the SQL for the report, very much like a Query.
Add the relevant tables and make sure you add all the fields relevant to the report from what ever table they are linked to.

Now I presume the above form has some sort of ID in the Criteria of the query add the folowing:

[Forms]![formname]![fieldname]
What this will do is look at the form you are in select the same record and print only that record.

So when you press the button in the background the program will search for the correct record that matched that of the one on the screen and print it.

hope this helps let me know if you are having any problems.

Zero Anarchy