2003 Glitch -- Search by last name not working

I have a database that searches 3 ways: by caseid, by last six of a vin and

by last name. After an automatic update the search by last name doesn't
work. 
This is a split datebase and two other computers running Microsoft 2003
one 
is still being able to search by last name but the others cannot. Here is
my 
code, this database has been running for over 5 years and I have never had

this problem. I am wondering if it was the update or something else. We
have 
repaired and compacted the database and that hasn't done anything either. 
PLEASE HELP!


Code for the three unbound comboboxes:
Private Sub cboFindByCaseID_AfterUpdate()
    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[CaseID] = " & Str(Nz(Me![cboFindByCaseID], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

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

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[CaseID] = " & Me![cboFindByDebtor].Value & ""
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
    
    'cboFindByDebtor.Text = Me![DbLastName]
    
End Sub

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

    Set rs = Me.Recordset.Clone
    rs.FindFirst "right([VIN],6) = '" & Me![cboFindByVin] & "'"
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub