How to suppress an error message?

[Guest]

I would like to suppress an error message from a subform with only one field.
First of all I would like to find out how can I get the error number
associated with
the error?
2ndly, how to suppress it?

I have only one field in this subform and when I open up the main form and
if this field is empty, I get error message, the object field is empty. I
would like to supress
this error message and also it shouldn't impact anything 'cause this field
could be empty in my case.

Any help would be highly apprecaited.

Thank you,
-Me

 

[Guest]

Use the form's OnError event:
If DataErr = 2211 Then 'or whatever your error number is.
Response=acDataErrorContinue
End If

Barry