How to filter 2 reports with 1 form?

tihmir

Registered User.
Local time
Today, 08:06
Joined
May 1, 2018
Messages
257
Hi all. I have a filter form. I wanna use this form to filter 2 reports and extract in pdf file. Here is my databese:
 

Attachments

Hi. You could try adding one more variable for the second report and then add one more OpenReport line to open the second report.
 
Hi. You could try adding one more variable for the second report and then add one more OpenReport line to open the second report.
Could you write it for example, please?
 
Could you write it for example, please?
In your code, you have these:
Code:
Dim strReport As String
...
strReport = "rpt_Inspections"
...
DoCmd.OpenReport strReport, lngView, , strWhere
All I'm saying is add one more to duplicate those lines. For example:
Code:
Dim strReport As String
[b]Dim strReport2 As String[/b]

...
strReport = "rpt_Inspections"
[b]strReport2 = "NameOfYourOtherReportHere"[/b]

...
DoCmd.OpenReport strReport, lngView, , strWhere
[b]DoCmd.OpenReport strReport2, lngView, , strWhere[/b]
Hope that helps...
 
check the Click event of the button.
 

Attachments

check the Click event of the button.
Something goes wrong, arnelgp . It show me this:


This is when I press button "Another Report"
 

Attachments

  • 1.png
    1.png
    4.6 KB · Views: 174
I am not sure Is it possible to create a report like this - one report with Inspections and AnoterTask to filter them with filter form with only one button
 
I am not sure Is it possible to create a report like this - one report with Inspections and AnoterTask to filter them with filter form with only one button

Of course it is, arnelgp has just done it for you, but expected you to write the code for the second report, using the first button as an example.?
 
I can not do it! I am trying but nothing :banghead::banghead::banghead:
 
don't bang your head.
this will appease you.
 

Attachments

you're welcome and go ahead make your next move.
 

Users who are viewing this thread

Back
Top Bottom