I have created a report with a sub-report. I have been able to filter the report based on a form using Forms!frmName!control in the query grid.
My problem is that I want to filter the report using a value from a sub form. I am using the same method, but keep being asked to input the parameter value.
I used the builder in the query grid so spelling is not an issue.
Any help greatly appreciated.
My problem is that I want to filter the report using a value from a sub form. I am using the same method, but keep being asked to input the parameter value.
I used the builder in the query grid so spelling is not an issue.
Any help greatly appreciated.