How to stop a DO .. WHILE loop

I have created a form in access and when it is loaded it automatically starts looking in a directory for a file. once the file is found it is moved and renamed and then begins checking in the original directory for that same file (the file is automatically generated from another system).

The form will be runnin all day but there will be times during the day where i may need to stop the form from doing what it doing in the background.

I have created a button and added debug.print "button has been pressed".

However it does not recognise when the button is pressed because it is to busy doing what it is doing.

How can i manually stop the looping process?

Try placing a DoEvents command in your loop;

VB Code:

Do While Power
    DoEvents
    ...
Loop

VB Code:

Do While Something
    Exit Do
Loop

Not

VB Code:

Exit WHile

?

nope - its a 'do' loop, 'while' or 'until' just specify the conditions for it to continue ;)