Update Database Using Text Boxes

[liquidspaces]

I've established the connection to the database, but I'm not sure of the syntax to write the value of a text box to a specific field in a table. Can anybody help?

 

I'm using Access 2000. For the sake of clarity, one of the database fields is called "FROM_NAME" and the corresponding text box on the form is called "txtFromName".

 

Thanks!

Edited November 21, 2002 by liquidspaces

[Derek Stone]

sSQL = "INSERT INTO myTable (FROM_NAME) VALUES('" & txtFromName.Text & "');"