i have a secondary form that dumps its info into a master report. The secondary form has a subform and there is a corresponding subform in the main report
Main form alreayd has ONE SAMPLE_ID listed on it
User submits on secondary form adding a new row, and a new SAMPLE_ID
When submitting, the code should look at the main form, see all the SAMPLE_IDs already listed on each row in the subform, and then add the new SAMPLE_IDs from the secondary form that are missing
so far, here is my code:
- for each row in FetchID.Linked_Samples
- for each row in Linked_Samples2
- NewRow = Product_Form.Linked_Samples();
The error i am getting is:
"Error at line number: 8
Variable SampleIDs2 does not exisit in ZC_SUBFORM_17"
SampleIDs2 exists in the SECONDARY form's subform. this error is telling me that it doe NOT exist in the MAIN form
i think deluge is getting stuck thinking that the "row" in line 8 still applies to the main form's subform (FetchID.Linked_Samples) , when really ive already closed that bracket and opened a new "for each row" which applies to Linked_Samples2 (the secondary form's subform)
I think this may be a deluge bug, but any other advice?