Printing only the current record

[Detectiveclem]

I would like to be able to print and email a single report showing only the detail of the current record I am viewing. At present I am able to set up the command button for printing or emailing, but the report relates to all my records rather than the record I am currently viewing.


I have looked at previous answers provided on this forum and viewed my code and only see the following.

Private Sub Command567_Click()



End Sub

I would be grateful if someone could assist me resolving my issue.

Thank you

[orange]

Tell us about your report and the record/table involved.
The DoCmd.OpenReport has parameters to identify the data to be used in the report.

See this article from TechOnTheNet on Opening a report ( to all records, or selected record)

[ranman256]

The report query would use the current ID on the form,

select * from table where [id]=forms!myform!ID

[Detectiveclem]

Hi again ranman256,

I am not sure what you are suggesting here? Do I need to add select * from table where [id]=forms!myform!ID to my code?


Sorry for being slow on the update, but I am still feeling my way with Access.

[June7]

Options:

1. Dynamic parameterized query as the report Recordsource - ranman is suggesting this but I never use them - then open report manually or with OpenReport command in code (macro or VBA)

2. Code (macro or VBA) that executes OpenReport command using its WHERE ARGUMENT to pass filter criteria - orange provided link to example