There MUST be an easier way!!??

There must be an easier way to add many controls to a database.

I have a form with 20 textboxes. I now want to write all these textboxes.text to fields in a database - the way I do it now is....

insert into table values ('" & txtbox.text & "','" & txtbox.text & "','" & txtbox.text & "','" & txtbox.text & "'
,'" & txtbox.text & "'......)


Isn't there an easier/quicker way??

Any suggestions please,

SS

Have you tried opening an ADO recordset and binding them to each control?

or just create a control array and use a for/next loop to build your SQL statement