Solved Multiple Subform Filter (1 Viewer)

[mfaisal.ce]

Dears,

I have a Report with 02 subreports. how can i filter the subreports all in one... , means normally if i have to open the report with filter option, where clause is used but how to filter multiple subreports once...

kindly guide....

regards,

 

[theDBguy]

Isn't setting up the Linked Master and Child Fields already enough?

 

[MajP]

As the @theDBguy said, normally subforms are linked to the mainform record. You filter main form and see child records. If that is not the case you will need to explain your set up

 

[mfaisal.ce]

There is no master child relationship between main and sub reports but i need to show multiple sub reports on one page by date filter... each subreport has Date field, so i want to show the subreports data based on date....

 

[theDBguy]

There is no master child relationship between main and sub reports but i need to show multiple sub reports on one page by date filter... each subreport has Date field, so i want to show the subreports data based on date....

Have you tried using using the date field as the linking field?

 

[arnelgp]

add Code to the SubReport's Open event:

Private Sub Report_Open(Cancel As Integer)
On Error Resume Next
Me.Filter = "[dateField]=#4/17/2021#"
Me.FilterOn = True
End Sub

 

[mfaisal.ce]

add Code to the SubReport's Open event:

Private Sub Report_Open(Cancel As Integer)
On Error Resume Next
Me.Filter = "[dateField]=#4/17/2021#"
Me.FilterOn = True
End Sub

it worked.... thanks a lot.... but i used a trick before your reply, i make a fake DateField and used master child relationship and passed parameter to DateField at Report open command....

thanks all....

 

[theDBguy]

it worked.... thanks a lot.... but i used a trick before your reply, i make a fake DateField and used master child relationship and passed parameter to DateField at Report open command....

thanks all....

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.