FindFirst method not finding

[Synergy TSI]

I am using Access2000 on SQL Server, and Windows2000 Server

This method is ignoring the criteria and always delivering the first record
in the table:

rsData is dimmed as a Recordset and is reassigned and set to nothing a
couple times prior to reaching this point.

Set rsData = CurrentDb.OpenRecordset("Ruleht w/ CP ST", dbOpenDynaset) ',
dbSeeChanges)
rsData.FindFirst "[cpID] = " & Parent.[ordCpNumber] & " And [brdcal1] = " &
Parent.[ordStockCaliper] & " And [Stock Type] = '" & [ordStockType] & "'"


I Remmed out the dbSeeChanges becuase I am using a local table temporarily,
but there is no difference when it is used.

rsdata.NoMatch always = False even when I put in bogus data.

I tried hardcoding the data with the same results.

rsData.FindFirst "[cpID] = " & 605 & " And [brdcal1] = " & 0.02 & " And
[Stock Type] = 'Generic'"


I am really puzzled here. I hope someone can solve this.

Thanks in advance

Synergy

 

[Synergy TSI]

I decompiled the database which solved the problem (so far).