form data into tables

  • Thread starter Thread starter courtney
  • Start date Start date
C

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?
 
Spammastergrand said:
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
 
Back
Top