Hi there.

I've implimented error handling and Access is not catching the errors and I'm getting the standard debug window. I've double/triple checked my code and it IS fine.

I'm,quite certain it's something to do with the settings in Access, however, I can't remember what it is.

Does anyone have any ideas as to how I can get round this.

I'l be grateful of any help I get.

Open any code module and go to Tools>Options...>General Tab. Error Trapping is on the right side.

Thanks RuraGuy for your help on this matter, worked like a charm

Excellent! Glad you got it working.