FindFirst method not finding

  • Thread starter Thread starter Synergy TSI
  • Start date Start date
S

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
 
Back
Top