Append Query Issue

[Voodeux2014]

I have created an append query to add data to my table tbl2GrantTrainers which has only two fields (GrantID ; TrainerID)



the append query is set up as follows:

field: ID
table: tbl1Grants
Append to: GrantID
Criteria: [Forms]![frmAddNewGrant]![ID]

field: ProviderID
table: tbl1TrainingProviders
Append to: TrainerID
Criteria: [Forms]![frmAddClassesToGrant]![cboTrainingProvider]



I get no error on the query, also have stepped through code and it executes the line of DoCmd.OpenQuery aqryAddTrainerToGrant but it does not actually add anything to the table. I know it is probably something simple that I am missing. Any help would be greatly appreciated.

[ItsMe]

While in design view of your Query, you can switch to SQL View. Post your SQL here so we can see a little more info.

[Voodeux2014]

INSERT INTO tbl2GrantTrainers ( GrantID, TrainerID )
SELECT tbl1Grants.ID, tbl1TrainingProviders.ProviderID
FROM tbl1TrainingProviders RIGHT JOIN (tbl1Grants LEFT JOIN tbl2GrantTrainers ON tbl1Grants.ID = tbl2GrantTrainers.GrantID) ON tbl1TrainingProviders.ProviderID = tbl2GrantTrainers.TrainerID
WHERE (((tbl1Grants.ID)=[Forms]![frmAddClassestoGrant]![cboGrantID]) AND ((tbl1TrainingProviders.ProviderID)=[Forms]![frmAddClassestoGrant]![cboTrainingProvider]));