Now THAT'S a neat idea. Nothing cheezy about THIS one, John.
Thanks
Barbara
>Hi Barbara ---
>
>I believe that it only applies (negative recnos) on tables that have been table buffered. A neat way to update appended records is to grab the last false recno (will be the lowest negative) and increment until 0.
>
>
>>As Edward said, you will get a negative value on an added record. If you wish to store a reference to a specific record, use the primary ID value instead of the Recno() value. The ID won't change, and can always be found with SEEK()
>>
>>HTH
>>Barbara
>>
>>>I have a code when I use the command recno and store it to a variable, but it has negative val.
>>>Why it happen....?