>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.