Thanks for the Select query. I should have thought of that, but that was helpful instead of running through the append query each time. Here is what i am seeing.
The initial run works great. If on the initial run of the append query i select 2 checkboxes in Pass_Fail, Then on the next run each additional box I check will add 3 records to the Comments table. if i initially select 3 then there will be 4 records added the second time run for each additional box checked.
here is my example of what gets appended on the second run after selecting 3 checkboxes on the first run.
Comment RCR_ID Contacts ID
This is a test discussion, components for normal process operations, Blow, Joe
This is a test discussion, components for normal process operations, Blow, Joe
This is a test discussion, components for normal process operations, Blow, Joe
This is a test discussion, components for normal process operations, Blow, Joe
Another Test Discussion, components for normal process operations, Blow, Joe
Another Test Discussion, components for normal process operations, Blow, Joe
Another Test Discussion, components for normal process operations, Blow, Joe
Another Test Discussion, components for normal process operations, Blow, Joe
I hope you get the picture the fields in the query are separated by commas.