form data into tables

[courtney]

Without binding form objects to a table how can you
update a table with the values entered into a form after
the form is complete?

 

[Hugh O'Neill]

I believe you would use insert into statements. Maybe create
variables for textboxes, like t1, t2, t3

Then buld a statement like qry1 = "Insert Into Tablename Values(" &
t1 & "," & t2 & "," & t3 & ")"

db.execute(qry)
(e-mail address removed)

Alternatively you could open a Recordset for the Table and use the
..Edit and .Update methods.

hth

Hugh