Solved Weird Behaviors Filtering a Report in a Navigation Form

[6thDAY]

That was in my comment earlier. Did you miss it? Or, maybe I wasn't clear.

Apologies, I must have missed it. Thanks!

And thanks @arnelgp for providing me with the foundation to guide me forward.

 

[6thDAY]

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:

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]

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:

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]

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]

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]

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]

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?