DAO Findfirst

[thechazm]

I have a dao recordset I am trying to goto a specific record to see if it is in the table but it does not seem to be working. Here is what I have:

I can view that the [Personnel Number] = 4340
and [Course Number] = "B005" here at the find first.
rsATMSInfo.FindFirst "[Personnel Number] = " & stblAutoNumber(i) & " And [Course Number] = """ & AtmsEnrolledCourseNum & """"


'// Adds new record if one is not found. Updates record if found.
But when I check to see if there is no match it goes to the else part of the if statement. I have verified in the table that 4340 and B005 do not exist so what am I missing?

If rsATMSInfo.NoMatch = True Then
rsATMSInfo.AddNew
else
rsATMSInfo.Edit
end if


Thanks,

TheChazm