Go to start of module 1

[TimTDP]

In Access 2000 I have a function. When the code is running and a particullar criterea is met I need to restart the code from the beginning
How do I do this?

 

[Remou]

As in Do While True?

Do while True
    'Stuff
  If Thing = Something
    Exit Do
  End If
Loop

 

[MichaelRed]

Go To XXY

On Error Resume XXX
(With a contional to Raise Err)

Recursion

are a few other possabilities



MichaelRed

 

[Zion7]

or, if it is truly from the start of the code,
you could recall the code,

Sub TimeCalc()
y = 12
Docmd.SendObject acReport.....

Do While x <> y
x = x + mintNumber
Loop

If x = y Then Call TimeCalc Else Exit Sub
End Sub

...the code makes no sense, but I have seen before,
a call to a sub, within the sub itself.

 

[VicRauch]

Calling a sub, or function from within itself is called "recursion" and is very powerful, but can be very disastrous too, if used incorrectly.

Of course, there is always the GoTo statement to take you right back to the start of your code.

 

[Zion7]

Thank-you VR,
I'm showing my ignorance here, it appears
M. Red, already brought up "recursion".

...if I only had my dictionary at the time!


...and yes, I was aware of the infinite iterations,
or multi-processing that could occur ,
(I guess as with any looping).