Code Window Opens With No Error??? 2

[alr0]

Hi All,

I added a new feature to a production application (Access 03). Everything works as expected except, the first time you use it, the code window opens to the "If" staement below. If I hit F5, it runs perfectly. All break points have been cleared yet this continues to happen intermitently.

'Check:User must have selected a case code
If IsNull([txtCaseCode]) Then
MsgBox ("You must choose a case code")
Exit Sub
End If

I encountered this once before with an app used by someone in the IT department. We never did find the cause and it never created other problems. This app is for less sophisticated users so I really need to resolve this issue.

Anyone seen this before or have an idea where to look?

Thanks,

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau

 

[PHV]

You may try to Cut'n'Paste the line of code and then compile the DB.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Eupher]

alr0,

This sometimes happens to me if I save the DB with a breakpoint set. Then, even after removing the breakpoint, it will break until I re-compile and re-save.

Ken S.

 

[alr0]

Thank you both,

PHVs suggestion did work but this point in the code was way before I had the breakpoint for debugging.

Another piece of very useful information to squirrel away.

Thanks again,

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau