>I am having a problem with Row buffering. Bufferred changes are being saved somewhere between the valid event of a text box and the click event of the save button. The location of the objects on the form has an impact on whether or not the error occurs. It is probably easiest if I describe how to reproduce the problem.
>
>Create a form with one table in the data environment.
>Set the buffer mode to optomistic row.
>Add a listbox to the top left corner of the form.
>Set the listbox.rowsourcetype to fields.
>Add a textbox below the listbox.
>Set the textbox.controlsource to a field in the table.
>Add a button to the top right corner of the form (beside the listbox).
>Add the tablerevert command in the click event of the button.
>
>The tablerevert will never work. Getfldstate in the valid event of the textbox indicates that a change has been made, but by the time the click event fires all changes seem to be saved. If I move the text box above the list box the problem seems to go away.
>
>For the time being I have resorted to always using table buffering.
>Any ideas?
Are you moving the record pointer in the table? This will cause the data to be saved.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer