Is it optimistic record or table buffering? If record then make sure the record pointer isn't being changed before the TABLEREVERT() because this will cause an implicit TABLEUPDATE().

>>What do you mean by TableRevert() don't work? Your post seem a little confusing to me, you are talking about saving record and TableRevert(). Are you sure you don't confuse TableRevert() and TableUpdate()?
>>
>>>I have a form whose properties are set to optimistic buffering.
>>>
>>>I have checked the cursorgetprop() of the tables and they all appear to be correct...but =tablerevert() still does not work. I thought the table was writing directly to the database, but changes are not evident to other users until the tables are saved, but revert still does not work.
>
>I apologize for the confusion. The issue is first setting up the form and databases correctly to utilize optimistic buffering. I think I have done this and validated it with the property cusorgetprop().
>
>Now that I have done this, I want to give the user the ability of selecting revert so their changes are not written to the database from the cursor. For this I have a command button whose caption is 'Revert' and whose click event is =Tablerevert().
>
>When I change data, and select 'Revert', the data gets saved regardless! Why? I don't know. Thats the problem.
>
>Thanks.