Bug with FindFirst? 1

[Goondu]

Access Version 2000.
Is there a problem with FindFirst with RecordSetClone? Does anyone knows a link?

Below is a sample code.

Private Sub Command0_Click()
Dim rs As DAO.Recordset
Set rs = Me.RecordSetClone
With rs
.FindFirst "CompanyID = " & """Chubb"""  'error Chubb-SP
If Not .EOF Then
Me.Bookmark = rs.Bookmark
Else
MsgBox "no match"
End If
End With
Set rs = Nothing
End Sub

DataType for CompanyID is Text. The ID "Chubb" does not exist in the table but "Chubb-SP" is.

The problem with FindFirst if I search "Chubb" I can find the record for "Chubb-SP"

Using the Query Editor with the criteria "Chubb" was unable to find the record.

Using DAO OpenRecordset is the same as the Query Editor.

Both the Query Editor and DAO works as it is but not RecordSetClone.

Changing the FindFirst with no luck.

 .FindFirst "CompanyID = " & """" & "Chubb" & """"
 .FindFirst "CompanyID = " & "'" & "Chubb" & "'"

Is FindFirst a Number datatype search only for RecordSetClone?

You can create a simple DB to try out. Just to see if you have a similiar problem with mine.

 

[TheAceMan1]

How are ya Goondu . . .

Try:

[blue]   With rs
      .FindFirst "CompanyID = '" & "Chubb" & "'"  'error Chubb-SP
      
      If Not .[purple][b]NoMatch[/b][/purple] Then
         Me.Bookmark = rs.Bookmark
      Else
         MsgBox "no match"
      End If
   End With
[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Goondu]

Hi TheAceMan1,

Thanks, I think I found out why. It because the record was on the first list in the form and initially I did use NoMatch. I mistook it for "FindFirst" for finding the record on the form. It was so strange that NoMatch did not work with the warning message box but now it's working. Need a break I guess.