how do u update a record using a textbox?

hello, i have a bunch of textboxes with datasource set to my adodc, and datafields, i can write in the textboxes over what is showing from my database, but it doesnt effect the database.

How can i make changes to the textboxes automatically update the database as well?

Thanks for your help :)
Ang

(Assuming locktype is not readonly)
You have to issue an adodc1.Recordset.Update command somewhere. Unless you movenext which automatically updates.

i would go with that

ooh that's perfect

cheers matey :)
Ang

your welcome :)
anytime the

did i see your name was Ang, as in Angela?

yes

i cant get the update to work :(
i have dis button, but i click it, then go back to see if it's work, and the changes havent been saved, any ideas why?


Private Sub cmdBack_Click()

adoProduce.Recordset.Update
DoEvents

Unload frmUpdateProduce
frmDatabases.Show 1

End Sub


thanks again
Ang

what the hell am i talking about! yes it does

sorry ignore my last post, it just didnt work the 1st time, it's ok now ;)

thanks all the same
Ang