Hi everybody,

I'm displaying the content of a recordset in a grid... If the user wants to change the information of a record in the recordset, I would like him to click on a button in the toolbar to display another form, or change the current Tab in a msTabbedDialog control to display some textBoxes to allow him to change the values...

Here's my question : I know that when you bind directly a textBox to a dataSource and a dataField, the value in the recordset is changed automaticly when the user leaves the textBox. I would like to know the better way to allow the user to change the values in the textBox(es) then click on a button to apply or cancel changes he just made. I'm not sure on how to do transaction with an ADODC control... And I find it complicated to put by hand all the values of my current record in my textBoxes then put it back in my recordset when finished...

What is the better solution for that ?

Thanks in advance