No Data Event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a 2003 database where when a user clicks a button 3 reports display.
On the No Data event I display a message a cancel the report. Unfortunately
if report #2 has no data the message displays cancelling report #2 but then
report #3 doesn't display even though there are records to display.

I tried changing the order of when each report which helped in this scenario
but will be problem if the new report #2 doesn't have data. The alternative
I suppose is to allow the reports to open with nothing. Any ideas on how to
solve this?

Thanks
LeAnn
 
I am willing to make a very small wager that the code has error-trapping and
that the error trapping does not use Resume Next if the error is 2501. The
error-handling code probably exits the procedure.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
John,
That was my expectation also. I'm not sure why people post problems with
their code and don't include the code :-( We need a term like paruresis that
is for shy coders.
 
Thanks John. I appreciate your reponse. I didn't however appreciate
Duane's. I have very little code associated wtih this report and didn't
think it would be relevant. I have posted my code here before.

I do have error trapping so I will add the appropriate statements to deal
with 2501.
 
Sorry if Duane's comment upset you, but he is correct. It is a lot
easier to diagnose problems when we get the relevant information. Our
psychic abilities are limited by an agreement with the Federal
government and several state and local agencies.

Glad I was able to guess at the problem... BUT it was a guess since I
was missing your code.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top