>It doesn't answer my question, how users moves between records.
>
>>
>>Right now, it's a single user system. However, I'll eventually change it to client server with the back-end being MS SQL 6.5.
>>
>>
>>>How users move between records?
>>
>>>While a user is on a form, how can I programically know when they have moved to a new record? I've tried storing the RECNO() in a variable (see below) and then update it through the REFRESH method but haven't been successful, yet.
>>>
>>>lnLastRecNo = RECNO()
SKIP +++++++++++++++++++++++++++++++++ (Sorry for butting in Sergey.)
>>>lnCurrentRecNo = RECNO()
>>>