seckel
asked on
Problem saving value to database using ADODC
I have a textbox (txtCode) bound to an ADODC object (adoUpdate) with the following properties:
DataSource = adoUpdate
DataField = dbField
I have a SAVE button that executes the following command:
adoUpdate.Recordset.Update
The following works:
I can click on the textbox and type a new code. When I click on the SAVE button, the typed code is saved to the database field.
The following does not work:
I can change the textbox using programming syntax (txtCode.text = "new code"). When I click on the SAVE button, the code is NOT saved to the database.
I need to pass a value to the txtCode.text property and then have the value saved to the database.
Any suggestions why my value is being saved when I TYPE the value in the object, but not saved when I CODE the value to the text property?
DataSource = adoUpdate
DataField = dbField
I have a SAVE button that executes the following command:
adoUpdate.Recordset.Update
The following works:
I can click on the textbox and type a new code. When I click on the SAVE button, the typed code is saved to the database field.
The following does not work:
I can change the textbox using programming syntax (txtCode.text = "new code"). When I click on the SAVE button, the code is NOT saved to the database.
I need to pass a value to the txtCode.text property and then have the value saved to the database.
Any suggestions why my value is being saved when I TYPE the value in the object, but not saved when I CODE the value to the text property?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.