Updating Multiple Tables

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a "master" table that is populated/updated via
a "master" form. I would like to insert a record with a
few fields from the "master" form into a "History" table
when the Master record is Saved.

I already have a History table built and populated with
the appropriate fields from the Master table.

Any suggestions?

Thanks
 
I have a "master" table that is populated/updated via
a "master" form. I would like to insert a record with a
few fields from the "master" form into a "History" table
when the Master record is Saved.

I already have a History table built and populated with
the appropriate fields from the Master table.

Any suggestions?
Click to expand...

Well, my first suggestion would be Don't Do This - storing data
redundantly is essentially never a good idea!

If you really want to do so, though, I'd suggest using VBA code in the
Form's AfterUpdate event. This code should open a Recordset based on
the history table, and use the AddNew method to open a new record;
fill it with lines like

recordset!field3 = Me!txtField3

and then use the Update method to write the record. See the online
help for Recordset for more details, or post back.
 
Back
Top