Need to pass parameter from Form to Report ADP

D

Drew

I have an ADP that I need to pass 2 values from a form to the SP as the
RecordSource in a report. I have tried this code,

Reports!EmpTitle.Report.RecordSource = spEmpTitle & "'" & ddlSWVTCTitle &
"', " & ddlStatus

Which returns the following error,

Run-time error '2451':

The report name 'EmpTitle' you entered is misspelled or refers to a report
that isn't open or doesn't exist.

But the report does exist and the RecordSource is spEmpTitle

Anyone know what is going on?

Thanks,
Drew Laing
 
Top