Coding Help please

[BigHappyDaddy]

Well dang!

Well, I am with Mark, you really need to step through using the debugger to determine where your code is going sideways.

If you are able to debug and find out something useful, feel free to post again if you are still unable to solve it on your own.

If anyone else is able to assist, feel free as well!

 

[MITSupport]

Hi Guys

I think i have figured it out.

I can remove the loop easily enough but i need to tell the routine to re query each time.

Please tell me if i am wrong

Allan

 

[MITSupport]

Hi guys i have figured out where the error lies but i dont know how to fix it.

When the first run of PrintRoutine is completed it retains the Original Case. I am trying to figure out how to get the routine to "reset" and on the .MoveNext select a new case as the ReportType field will be different on each instance.

I have stepped through the code and the Loop works fine for the same "ReportType" but it goes off centre when a different ReportType is thrown into the mix.

So in essence the question i am asking is it possible to have the SELECT CASE statement inside of the Loop?

Allan

 

[MarkK]

Here are a few questions.
Why is there a loop? This subroutine is passed one ReportType, and the query that controls the loop, qryReports, doesn't appear to know what that report type is. How does that makes sense? What data is provided by qryReports? What is the subroutine supposed to do?

Mark