Solved Weird Behaviors Filtering a Report in a Navigation Form (1 Viewer)

6thDAY

Member
Local time
Today, 11:10
Joined
Oct 10, 2021
Messages
36
On a side note, I'm facing another issue that is related to this, so I hope it's ok I just post in here.

How can I access the filter criteria of the report based on the LinkMasterFields and LinkChildFields linkage?

I tried to do the following, but str returns an empty string:

Code:
With Me.subreport_TestReport
    .LinkMasterFields = ""
    .LinkChildFields = ""
    str = .Report.Filter
End With

I want to be able to print the report based on the filter criteria, but I cant seem to access the filter string in the report.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:10
Joined
Oct 29, 2018
Messages
17,123
On a side note, I'm facing another issue that is related to this, so I hope it's ok I just post in here.

How can I access the filter criteria of the report based on the LinkMasterFields and LinkChildFields linkage?

I tried to do the following, but str returns an empty string:

Code:
With Me.subreport_TestReport
    .LinkMasterFields = ""
    .LinkChildFields = ""
    str = .Report.Filter
End With

I want to be able to print the report based on the filter criteria, but I cant seem to access the filter string in the report.
How did you apply the filter in the first place?
 

6thDAY

Member
Local time
Today, 11:10
Joined
Oct 10, 2021
Messages
36
How did you apply the filter in the first place?

the filtering is done using code in AfterUpdate, linking Master Fields (combo boxes) and Child Fields (column names in report) together.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:10
Joined
Oct 29, 2018
Messages
17,123
the filtering is done using code in AfterUpdate, linking Master Fields (combo boxes) and Child Fields (column names in report) together.
Ah, that's not applying a filter to the form. The linked fields are a separate functionality.
 

6thDAY

Member
Local time
Today, 11:10
Joined
Oct 10, 2021
Messages
36
Ah, that's not applying a filter to the form. The linked fields are a separate functionality.
In that case, is there a way to access the state of the report when the fields are linked?

Filtering the report leads to the original issue of this thread.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:10
Joined
Oct 29, 2018
Messages
17,123
In that case, is there a way to access the state of the report when the fields are linked?

Filtering the report leads to the original issue of this thread.
Not sure about that. Have you checked maybe the report's recordset? I thought you said in post #9 that the filter problem was already solved by Arnel's demo?
 

Users who are viewing this thread

Top Bottom