>>The main screen in our system was running very slow with a filter set on. We found that by adding the command "SET REFRESH TO 0,0" the form runs much faster. It had always been at "0,5" and we never paid any attention to it. It always worked until our largest customer got 6 years of data. I now need to know if there is a command to do a data refresh. (not the form refresh) If you run the form and skip through the data it will not show changes made by another user on the network until you lock the record. I am drawing a blank here but I know there is a command to do this.
>>
>>Thanks in advance.
>
>If you issue a lock on a record in the table or on the table header, the data will be refreshed in the local cache.
>
>rlock(0)
>unlock
>
>You could stick this in a timer on your form or just call it when you need it.
>
>HTH.

Larry,
thanks for the reply. I was hoping there was some other way. Having a timer fire off after about 2-3 seconds of inactivity is a good idea but locking the record seems extreme. Some of my customers are still running Novell and it has problems releasing record locks sometimes so I would rather not go that way.
Thanks for the input.