Carmen, you can do it using CURVAL() and OLDVAL() functions.
>Is there any way to prompt the message where there have two person updating the same record.
>
>For Example: I Have the form called sales booking for the housing.
>Two people retrieve the same record and then one is updating information at the same time the other one will the message said 'some have updating this record'.
>
>Is it possible to do this in vfp. I have not using the control source to bound the data.
>
>
>I create the cursor to list the data into the grid called listform with the button called Refresh Screen, this button is used to updating and refresh the data. e.g someone have updating the record,
>Once I press this button, It Supposed data to be displayed in the grid, It not run ok for the first time, I have to exit the form then
>i get in the form then press the refresh button, then the data list out. It feel like delaying a few minute.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison