I have a report COMMUNICATION BY LOCATION that uses the query CommLine, which is based on the dialog box SelComTypeLoc.
The criteria for the query is [Forms]![SelComTypeLoc]![cLoc]
When I open the dialog box SelComTypeLoc and enter my value (cLoc) into a drop down box, the query executed properly.
I am trying to open the report and run it based on the values set in the dialog box SelComTypeLoc to run the query CommLine.
The report record source cannot be the form SelComTypeLoc.
How can I have the report run the dialog box to select the query values?