Form based on multiple tables

S

Shaldaman

Hi,
I have a form that has fields from 4 different but related tables.
Currently all the fields are unbound. Is there a way that, after either
closing the form or on the click of a button, I can have the values
from these fields stored in the respective tables? Does the
"DoCmd.RunCommand acCmdSaveRecord" command have an option where we can
specify a table for each field.

Thanks
 
G

Guest

Look in help for the DoCmd.RunSQL command for updating tables and inserting
new records into tables.

DoCmd.RunSQL "UPDATE
.....
DoCmd.RunSQL "INSERT INTO ....
 

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

Form with Multiple Tables 1
Form will not display records 3
Saving a recordset on a form 4
form based on table + combobox 1
Multiple Tables 10
Creating tab pages in a form based on multiple tables 3
Form wizard not showing both tables - Access 2007 1
Form from several tables 1

Top