highlight code error

[guamlet]

Is there a way to make VBA highlight the area of the code where a problem exists? Sometimes I get the "Item not found in this collection" error, and all I can do is press "ok" on the error box and the code terminates. In excel, wherever there is an error, VBA highlights said error...is there a way for it to do this in Access so I don't have to comb through a ton of code to find a spelling error?

 

[Russell Hauf]

I suggest stepping through the code or setting breakpoints at various locations before runing the code. You can quickly narrow it down that way. Post back if you need help doing this.