Transferring Data From One Table To Another

Hi all. Hopefully this will be a simple thing...What I have is one main table (RFA Main) and two related tables (S/R Disposition and Suppliers). RFA Main has a two check boxes (ScrapRewrk and SupActs) that I am using to trigger append queries that append the following SQL statement:
Suppliers table
INSERT INTO Suppliers ( LogNum, Originator, ReportDateOp, PartNum, PartNumDesc, ProbDesc, CustRtn, RmaNum )
SELECT [RFA Main].LogNum, [RFA Main].Originator, [RFA Main].ReportDateOp, [RFA Main].PartNum, [RFA Main].PartNumDesc, [RFA Main].ProbDesc, [RFA Main].CustRtn, [RFA Main].RmaNum
FROM [RFA Main]
WHERE ((([RFA Main].SupAct)=True));

S/R Disposition table
SQL the same except for the WHERE statement reads ((([RFA Main}.ScrapRewrk)=True));

First, what kind of statement would I use to trigger the append query when the boxes are checked? Currently, the users are doing these append queries manually by clicking command buttons.

Second, is there an easier way to do it?

Thanks in advance

Camille