CurrentDb.Execute "INSERT INTO tblTestReport ( TestDetailID, TestID, ReceiptID, ParticularsID, PARTICULARS, RESULT, UNITS, MALE, FEMALE, ABNORMAL, PartHead, PartHeadID ) " _
& " SELECT tblTestDetails2.TestDetailID, tblTestDetails2.TestID, tblTestDetails2.ReceiptID...