Error Checking Problem in Access 2003

[ftook]

In access 2003 I have a small amount of code, I have mistyped a control reference in the code ie. instead of
me![codeval] i put [me1[codval], in Access 97 an error message appeared when i try to run, but im not getting this in 2003, all error checking turned on - please help if u can.

[KeithG]

IF you compile your code that should catch the error

[ftook]

Compile not showing error and even set warning to true in immediate window doesnt help - any ideas would be so welcome.

[gemma-the-husky]

I don't understand - how do you know this is happening if the code isn't stopping.

why cant you just do a global search and replace to find all instances of me1 to fix it anyway.

Also it depends where you put it - if eg this is in the middle of a sql string you might find the code just prompts you for a veriable with the prompt, or alternatively it may just be looking for a field called

"me1[codval", which is the contents of the square brackets.

[RuralGuy]

I believe ftook imported everything into a fresh new mdb and it started showing an error. I remember this from another forum.