Assigning Values from textbox on Form to recordset

[Guest_imported]

How do you assign values from a textbox on a form to a recordset.

Using VB6 / Access2000, ADO

Thanks

 

[savok]

you open a connection to the database and then insert or update it with the info from the textboxes depending on what you want to do

Dim objConn As New ADODB.Connection
Dim objComm As New ADODB.Command
objConn.ConnectionString = "DSN=*;UID=*;SERVER=*;PWD=*"
objConn.Open

objComm.ActiveConnection = objConn
objComm.CommandText = "Update table set field= '" & txt & '"
objComm.CommandType = adCmdText
objComm.Execute
objConn.Close

 

[Guest_imported]

Thanks Savok

Worked a treat.