What's happened to the findfirst function in Access 2010?

[Dadders]

I have a working Access 2007 Application which is now failing miserably in
2010. It hinges on location the first available working document in a table
runing the following VBA code:
With Me.Recordset
.FindFirst "([fld1] + [fld2]) = 0"
If .NoMatch Then
.FindLast "([fdl1] + [fld2]) <> 0"
Exit Sub
End If
.... FURTHER PROCESSING ...

What must I do to correct this? Go through a record by record search?
End With
In 2007, this works correctly, stopping at the appropriate record (approc.
rec 1385 in the recordset). In 2010, it stops at record 79

 

[Tom van Stiphout]

On Sat, 5 Dec 2009 15:58:01 -0800, Dadders

What are the values of fld1 and fld2 in both scenarios?

-Tom.
Microsoft Access MVP

 

[silvinha]

I have a working Access 2007 Application which is now failing miserably in
2010. It hinges on location the first available working document in a
table
runing the following VBA code:
With Me.Recordset
.FindFirst "([fld1] + [fld2]) = 0"
If .NoMatch Then
.FindLast "([fdl1] + [fld2]) <> 0"
Exit Sub
End If
... FURTHER PROCESSING ...

What must I do to correct this? Go through a record by record search?
End With
In 2007, this works correctly, stopping at the appropriate record (approc.
rec 1385 in the recordset). In 2010, it stops at record 79