Linking Form Information Into Two Tables

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

Guest

I am trying to create a form, that when I enter information into this form,
it'll disperse into two different tables.

The field names and design of the content needed for both information are
the same.

I need HELP! Thanks!
 
You will have to do some code on the AfterUpdate of the form, that populates
the 2nd table.

quickest way is with an Append Query and a DoCmd.Runsql

For example, run this for the Customers Form in Nwind

DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT INTO Customers2 SELECT Customers.* FROM Customers
WHERE Customers.CustomerID='" & [Forms]![Customers]![CustomerID] & "'"
DoCmd.SetWarnings True
 
Back
Top