>>>Chris,
>>>
>>>I would use LOCATE FOR RECNO() = Value if I ever needed to position on a certain record by RECNO(). However, I don't use RECNO() to find records I use the PK value instead.
>>
>>So that's 3 different ways of getting to the same place
>>
>>Locate RECORD lnRecord
>>Locate for Recno() = lnRecord
>>GoTo lnRecord
>>
>>Is there a best one or is it just preference (I'm using this code to ensure that any table is on the correct record after something that might move the record pointer has finished so a primary key is not an option).
>
>
locate for recno() = lnRecord will surely be slow, unless you happen to have an index on recno().
>
>Hilmar.
Thanks Hilmar, any thought on which of the other 2 should be the fastest?
Caroline