Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making changes on a recordset
Message
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00635027
Message ID:
00635078
Vues:
21
This message has been marked as the solution to the initial question of the thread.
Don't use binding when you want full control like this. Write your own code to populate controls when moving from record to record and in the button click event update the recordset.

>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
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform