docmd.findrecord does not return error message

[rene1000]

When i lookup a record with the command:

docmd.findrecord string

it works fine, however when the string does not exist it returns to the form without an error message. how can i run some vb code whenever the string does not exist in the record ?

any help is greatly appreciated.

 

[jbento]

Try this:

If IsNull(FieldName) Then
MsgBox "Where is the information in field 1?", vbExclamation
field1.SetFocus
End If

I think that might work for you

GOD bless,