Search results

the query is puling data but when we docmd.openreport "rptoverdue".acviewpreview then no data is accessed by the report eg If we insert state as AZ and run the query then query pulls records,say 5,the report also pulls 5 records but when called through the form the report does not show data.

It is still not working.

i want to use a query "above45" to show the report "report overdue".The query takes "state" from form frmoverdue "cbostate" combo box. i am using docmd.openreport "report overdue",acviewpreview","above45","[state]=Forms![frmoverdue].[cbotext].[seltext]" but I am not getting the data.I am...