Can't find the data source (1 Viewer)

[mg123]

I have been asked to modify a report that my company uses. The report has been around for a long time, the person who wrote it is long gone and I know almost nothing about Access...

When I go into the design view on this report and look at Properties ->Data and choose "Report" from the drop down box I find a query that goes against a SQL database. I copy paste this query into SQL and get 1486 records back, however, when I run the report itself I get close to 2,000 records back. So I am trying to figure out where else to look to identify where this report is getting its' data from?

Any ideas as to where else I could look to find other queries that this report might be using to get its' data would be greatly appreciated.

Thanks!

 

[macca the hacke]

Can you post the recordsource of the report, and any other event procedures behind the report

 

[mg123]

Thanks for the response. I have figured this one out.