Report error: you entered

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hello everyone!

My problem is nearly identical to the problem Bruce had below, except
that I am having the problem with a report, and cannot seem to use the
Recordset or RecordsetClone objects. How can I test in a report if
the application of a filter results in no records?

I tried just catching the error, but the result is not as elegant as I
would like. I would much rather test for the known condition that
causes the error.

Thanks in advance!
Todd Tomashek

Bruce,
Click to expand...
 
You mean a Filter in the DoCmd.OpenReport, or a Criteria in the
RecordSource? That's what the OnNoData event is for. Otherwise, you could
open a Recordset in code on the "filtered data" with the same SQL and
criteria and check prior to running the report. That's what some did before
there was a NoData event.

Larry Linson
Microsoft Access MVP
 
Back
Top