sql help - adding subrecords (vba)

[joltremari]

I have a form with 2 subforms that are all relational:
Table1 = Form
Table2 = subform1 (subrecords of Table1)
Table3 = subform2 (subrecords of Table2)

I am trying to write an sql statement to add records to subform2(table3) based on a record in subform1. (unsuccessful so far)

something like:

"UPDATE Table3 Set field1= ValOne And field2 = ValTwo Where(Table2![field1] = """ & i & """);"

This did not work by the way

I hope I explained this so it is clear what I mean...if it is not I'll try again.

Thanks for any help or advice...

JO