FindFirst - to locate the 'highest' field value ?

[liamfitz]

Can I use the rs.Findfirst ( where 'rs' is a recordset ) method to locate a record, one field of which, has a 'Long' data type value, which is the biggest number ( because this is an Auto Number Primary key, it SHOULD be the most recently created record - which is what I actually want to ensure I find ) Hope this makes sense, so something like ...

rs.FindFirst "[Referral_Num] > " & every other Referral_Num field value in Recordset.

Thanks.

 

[pbaldy]

I don't think so. If that's the only record you need, open the recordset with the TOP predicate:

SELECT TOP 1...

With the appropriate sorting.