append a record from a form to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to take the result of the form and append or insert it into a table
 
I need to take the result of the form and append or insert it into a table
Click to expand...

Either use a SQL statement to insert it, or take the really easy way
out - bind the form to the table. (Set the rowsource property of the
form to the table you want to store the data in. then set the
rowsources of the controls that you want to save.

Pretty much happens automatically when you create a form based on a
table or query using a wizard.
 
Thanks

[email protected] said:
Either use a SQL statement to insert it, or take the really easy way
out - bind the form to the table. (Set the rowsource property of the
form to the table you want to store the data in. then set the
rowsources of the controls that you want to save.

Pretty much happens automatically when you create a form based on a
table or query using a wizard.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append only Null records in table 2
append query not appending 2
Loop (ADODB) from continous form 2
Append one record into a table from form fields 2
Appending records 1
Append current record from one table to another 11
Skip Records in a Form 2
Append Query 11

Back
Top