S
Sandy
I have a series of episodes, each of which can generate a report. I have
written a short routine to generate a report that loops through each of the
previous episodes, in effect showing all the previous reports in a single
report based on a query.
Most of the time this works fine but, from time to time, even though there
are previous episodes (sometimes many), the NoData event fires. I have tried
to compare the records of such individuals with others but cannot come up
with the answer. Is there a logical debugging sequence that I can use in this
situation?
I should add that this problem is consistent within an individual's record.
When I am unable to retrieve documented previous episodes it always occurs.
In other words, it isn't an intermittent problem.
Any help much appreciated.
Sandy
written a short routine to generate a report that loops through each of the
previous episodes, in effect showing all the previous reports in a single
report based on a query.
Most of the time this works fine but, from time to time, even though there
are previous episodes (sometimes many), the NoData event fires. I have tried
to compare the records of such individuals with others but cannot come up
with the answer. Is there a logical debugging sequence that I can use in this
situation?
I should add that this problem is consistent within an individual's record.
When I am unable to retrieve documented previous episodes it always occurs.
In other words, it isn't an intermittent problem.
Any help much appreciated.
Sandy