E-mailing of just the current report from a form?

B

Bob

The easiest way that I know of to do that is to create a
report and send the report filtering for the ID of the
current record on the form.

You can save the form that you're currently using as a
report but you may have to do a little bit of altering. If
the form has a subform you'll have to convert all subform
to reports too and link them in report design.

Apply the filter to the main report and just send the
report via email. The filter would be something like:

[TableOrQueryName]![FieldName]=[Forms]![YourFormName]!
[YourFormControlName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass a value from a Form to a Report 6
Trying to Open subform on click event to current record from main form 2
Refresh data in sub forms when one sub form is edited 8
Filter report records from form 3
Print Report using current data on Form 2
Master - Child links not working in 2007 0
Master Child link being broken. 2
Trying to use the filter on the form to filter report 3

Top