Here's my code: (dates are in mm/dd/yy format)

Report.RecordSelectionFormula = "{ado.Date} = in '" & strDate1 & "' to '" &
strDate2

CRViewer1.ReportSource = Report
CRViewer1.ViewReport

everything seems fine until the report loads and I get the following message
in a vbokonly box:

A number, currency amount, boolean or string is expected here.

Any suggestions?

Thanks in advance