Good day Eric,
I need your help again if you've got a minute.
If I am using the two adodc connections along with two tables and forms that are linked with SQL how can I add records and save them in the second table? The adodc SQL that I use (per your suggestion) to link the tables from the first form is: SELECT * FROM FirstTable AS Old
LEFT JOIN SecondTable AS New
ON New.CustNum = Old.CustNum
When the second form is loaded I use the code you suggested again:
Set firstForm.adodc1.Recordset = secondForm.adodc1.Recordset
How can I get the second table to add a new record? Since it is linked using the adodc SQL I am unable to use "Adodc1.Recordset.addnew" property to create a new record in the second table as the adodc on the second form is set to show the recordset of the first table.
Thanks for your help in advance!!
Max