I hope someone can help with this problem...

I have a form that lists a customer table. I created a "find record" - unbound control that will allow the user to type in the first letter of the person and it will bring up that record.

The problem is if that person is NOT in the table, the user gets an error that a NULL is not allowed.. and then they get another error

RUN TIME Error 94

Invalid use of Null

Following is the code behind the Form,,

Private Sub Combo224_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Cust ID] = " & Str(Me![Combo224])
Me.Bookmark = rs.Bookmark
End Sub

Any idea as to what I can do to take care of this problem???