Problem in requery of reports in acess 2003

[pratim09]

I have a report named rptHoursTracking and a strSQL statement for fetching data from database according to some criteria.
Report form name is frmReport .On the click of search button in the frmReport I am trying to show the report with thebelow code .



DoCmd.OpenReport "rptHoursTracking", acViewReport
Report_rptHoursTracking.RecordSource = strSQL
Report_rptHoursTracking.Requery

The requery is giving compilation error as method or data memeber not found .The above code is working fine in access 2007 but 2003 is giving the problem. How do I change the code to work in 2003 as we need to deploy in 2003 machine. Any help will be highly appreciated.

[rpeare]

You don't need the requery when opening the report. Set the recordsource FIRST, then open the report and you shouldn't have any difficulty.