Hi -

As long as both form1 and form2 are still open (it's not clear from your
explanation whether that is true or not), you can use SQL to do the
insert, making sure your references to the form1 files are fully
qualified, thus:

insert into table3 fields ..... values( forms!form1!field1,
forms!form1!field2, me!field1,....)

where me! refers to form2.

The above is just pseudo-SQL, of course; the roal code is more complex,
to put in commas, and quotes where required.

A suggestion: put this code to append to table3 in the on click event
for a "Close" command button on form2, then use docmd.close to close the
form.

Hope this helps

John