Hi,
i am writing an onclick event vba which insert values in my form to 2 different tables in one click. A main table and a subtable.
The subtable is linked to the main table by a field called MainTableIndex and the main table generates the Index by autonumber.
My question is how do i reference the main table index which is yet to be generated and insert it into the subtable sql.
i am writing an onclick event vba which insert values in my form to 2 different tables in one click. A main table and a subtable.
The subtable is linked to the main table by a field called MainTableIndex and the main table generates the Index by autonumber.
My question is how do i reference the main table index which is yet to be generated and insert it into the subtable sql.