Transferring Data from a Form to a Report

[kenner]

I have created a form and a report that is fed through the form by a toggle button. Currently, the report is always showing the 1st record. I need the report to always show the record that I'm on.

 

[mcadle]

Use a filter or where clause in your open statement. Try something like this:

DoCmd.OpenReport "ReportName", acPreview, , "[Fieldname] = """ & Me.[Fieldname] & """"

Hope this helps.