Error Handling

[mollow]

Hi,

I was wondering if any of you guys could help me with a little problem I have.

I keep getting error 3201 on one of my forms that forces a break in the visual basic. I want to handle this error so it doesn't do this, instead pops up a MsgBox saying "blahdy blahdy blah".

I have played around with the ON Error property and added On Error GoTo X in my seperate visual basic bits. However, MS Access throws a wobbley at me, I have obviously not written the code correctly.

So my question, really, is where do I put my error handling code, and what should the code be that deals with Err.Number 3201?

Thanks in advance,

Mike

 

[mollow]

Haha,

blummin typical, no sooner do I post this message I figure out how to do it

Thanks anyways

Mike

 

[ThePieman]

how did you do it??