var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Error In Find Code
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
Any idea as to what I can do to take care of this problem???