No Data Event

[LeAnn]

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

 

[Duane Hookom]

Show us your code.

 

[John Spencer]

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
..

 

[Duane Hookom]

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.

 

[LeAnn]

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.

 

[John Spencer]

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
'====================================================