>I'm in the process of debugging some code that I inherited from the programmer before me...and there is a query which is executed that will not refresh. (i.e. to rerun the query you have to exit and then re-enter the form.) The last line in the code does include a ThisForm.Refresh statement. Is there anyone out there who'd be willing to take a look at the code...it's 289 lines...Thanks...
>
>-Lukasz

Just prelimiary comments about the code. Usually you will not to go more than 3 levels deep when coding. The levels I'm referring to is any code that can cause a branch in execution. If, DO CASE, FOR. My suggestion to you is to break down this code into method or function calls.

Not only is it easier to read but it also easier to debug.