Form based on multiple tables

  • Thread starter Thread starter Shaldaman
  • Start date Start date
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
 
Look in help for the DoCmd.RunSQL command for updating tables and inserting
new records into tables.

DoCmd.RunSQL "UPDATE
.....
DoCmd.RunSQL "INSERT INTO ....
 
Back
Top