report is using a query & report is sometimes missing data

[Wanetta MemberForm]

My report doesn't always return the same information as the query I am
running the report with. The report is called from a form and the form
passes the selection criteria to the report. This same form calls two
different reports and use the same selection for calling the reports. One of
the reports returns data and the other one doesn't. What is causing this?
From the same form, I also sometimes get a message "macro not defined" when I
select a report to preview. Again, sometimes this works without me receiving
the error. I don't know what to look for. Please give suggestions.

Thanks

 

[Damian S]

Hi,

Open each report and check that the data source for each report is the same
as you expect them to be. If they are slightly different (eg: one shows only
Active records or something like that), even if you pass the same criteria
the results will be different.

Damian.