report from a single record displayed on the form

  • Thread starter Thread starter Al Heyne
  • Start date Start date
A

Al Heyne

Hi all, any help on building a report based on a single
record displayed in my form? I'd like to put a button on
the form that sends a report for the record currently
shown on the form via email to my client.
Thanks in advance
 
Al Heyne said:
Hi all, any help on building a report based on a single
record displayed in my form? I'd like to put a button on
the form that sends a report for the record currently
shown on the form via email to my client.
Thanks in advance
Click to expand...

The DoCmd.OpenReport method has an optional WHERE argument which uses the
same syntax as the WHERE clause in a query, but without the word "WHERE".
You would use that to apply a filter to the report as it is opened that
only returns the record currently being viewed on the form

For example; if both the form and report included a numeric Primary Key
named "ID" then you could use...

DoCmd.OpenReport "ReportName",,,"[ID] = " & Me.ID
 
You must log in or register to reply here.

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

Access Automatically Send a notification email once a record is added 0
Access Access Report Works on One Machine but not Another 3
Query/Report Output Based on Current Record in a Form 3
Alter Report Captions from a Subform 3
Button on form to print report for current record 4
How to see a report in a form 3
Access 2010 Report Button 0
Generating a report that includes only the current form data 1

Back
Top