Subform calling in StrSQL Insert Into

arnel_gp 

well it turns out that I had a mistake (my field in the target table to 'insert into' was IDRollsFK not IDRollsPK) and once I fixed that I then reverted back to what I originally tried (no subform calling) and it inserted to my surprise:
strSQL = "INSERT INTO tblFXRollsChildHist (IDRollsfK, AmountHist) VALUES (" & [txtIDRollsPK] & "," & [AmountRoll] & ")"
I also dont need Me! and I always thought I needed Me! It works either way though I confirmed in my testing. 

It looks like I am good now but adding extra comments in case others read:

I also tried referencing the subform but I still got the runtime error 2465 message (above pic in original qstn): note that [amountroll] (I didnt name it as txtamountroll and I should have and since I have code attached to it I dont want to change it) field is also in the subform
strSQL = "INSERT INTO tblFXRollsChildHist (IDRollsPK, AmountHist) VALUES (" & [subfrmFXRollsChild].[Form]![txtIDRollsPK] & "," & [subfrmFXRollsChild].[Form]![AmountRoll] & ")"

I am surprised the code fires and inserts without referencing the subform. I believe in most cases when dealing with an unbound form with a subform and if you need to reference a field on the subform you need to use [subformname].[Form]![name of field] (and sometimes add the parent name of form in front of subform).
Maybe I dont need to reference the subform since the subform is in the footer and is not in the detail section. I confirm that the form frmFXTracker is unbound though.

harun:  I also tried to reference the parent form (frmFXTracker) but I still got the runtime error:

 strSQL = "INSERT INTO tblFXRollsChildHist (IDRollsfK, AmountHist) VALUES (" & [frmFXTracker].[subfrmFXRollsChild].[Form]![txtIDRollsPK].[IDRollsPK] & "," & [frmFXTracker].[subfrmFXRollsChild].[Form]![AmountRoll].[AmountRoll] & ")"

Anyways, it looks like its inserting as it should.  thanks again for the help guys.  Still a little confused why I dont need to reference the subform.  have a good weekend.