I want to create a VBA program that will monitor Table 1 and when an update is made ( a new record is added to Table 1) it would run a query or vba code that would take the newly inserted record from Table 1 and insert into Table 2.
I want this VBA program to constantly run so that it keeps...
