Opening reports from within a report.

[Herbolife]

Hello everyone,

The question I have is a little hard to explain for me, so please bear with me.

This report displays all records from a table named "hardware" in an overview. To the right you'll see each record comes with a button named "details"





I also have a report for details, which shows a specific record with additional details which it gets from both "Hardware" and another table. This report works with a query which is dependant of the "HardwareID" value. For example, when you enter "2" in the query, it'll grab all the details from that record.





What I want is that if you press the "Details" button on the overview report, it automatically grabs the HardwareID of that value, and uses it to run the query and thus get the corresponding details report.

If any additional information is required, please let me know.

Thanks a lot in advance for your time

Greetings,
Sebastian

[June7]

Reports are not really intended to be interactive. Buttons won't work in Print Preview. If the reports are not to be printed and don't have any fancy grouping and sorting, why not use forms? Forms are intended for screen display.

However, try the WHERE CONDITION of DoCmd.OpenReport

DoCmd.OpenReport "reportname", acViewPreview, , "HardwareID=" & Me!HardwareID

[Herbolife]

Hey June,

Thanks for your reply. As for the reports, they are supposed to be printable (both of them).

After goofing around with the code you gave me a little I got it to work exactly as I wanted (only replaced acViewPreview with acViewReport). Did a few tests and it's working perfectly now.

So thanks a lot, you've been most helpful

Cheers!