how do u update a record using a textbox?

[Psycho_NZ]

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

[ralph]

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

[Devioux]

i would go with that

[Psycho_NZ]

ooh that's perfect

cheers matey
Ang

[Devioux]

your welcome
anytime the

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

[Psycho_NZ]

yes

[Psycho_NZ]

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

[Psycho_NZ]

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