I have a Navigation Form with 2 buttons, 1 filter combo box, and a subform beneath containing a report. Each button displays a different report in the subform. The combo box filters the same field in both reports.
It looks like so:
The subform in the Navigation form is linked based on their LinkMasterFields and LinkChildFields properties.
When the navigation is opened, the first report is displayed. However, filtering the value for the field Animal using the combo box does not filter the report, nor does the value in the combo box get retained. Every selection made in the combo box disappears.
However, if I click the button Table2 to display the secondary report, filtering works fine and the value is retained in the combo box after selection.
Clicking Table1 to display the first report again results in the filtering issue.
This issue is related to the following post, in which @arnelgp graciously helped me with:
Solved - Weird Behaviors Filtering a Report in a Navigation Form | Access World Forums (access-programmers.co.uk)
Attached is the demo representing the issue.
@arnelgp if you are available, can you provide assistance since you helped me resolve the above related issue?
It looks like so:
The subform in the Navigation form is linked based on their LinkMasterFields and LinkChildFields properties.
When the navigation is opened, the first report is displayed. However, filtering the value for the field Animal using the combo box does not filter the report, nor does the value in the combo box get retained. Every selection made in the combo box disappears.
However, if I click the button Table2 to display the secondary report, filtering works fine and the value is retained in the combo box after selection.
Clicking Table1 to display the first report again results in the filtering issue.
This issue is related to the following post, in which @arnelgp graciously helped me with:
Solved - Weird Behaviors Filtering a Report in a Navigation Form | Access World Forums (access-programmers.co.uk)
Attached is the demo representing the issue.
@arnelgp if you are available, can you provide assistance since you helped me resolve the above related issue?