[Pettor]

Hi guys, I would some help with the below.
I have a form, in which, the user enters some data and updates a table. This form opens through a button from a previous form where some specific data are retrieved and presented from a different table.
What I would like to do, is the empty form to get into some fields data from the previous form, by default, and then the user to fill in the rest by hand. After that, the whole record needs to be stored in a different table.
Since the form that needs to update the new table has a "recordset source" linked with the table that finally needs to get updated, I can not bring the data I want from the previous form that has the details that need to be autofilled.
So, to make the example realistic, let's say that I have a table with a list of houses and their addresses that is presented in a form.
I select one of them, and through a button, a new form opens with the data of a specific house.
Then I want a new button inside this last form to open a third form where some data will be auto-filled (let's say the address of the home) and the user will enter some additional info, with data irrelevant to the initial table, where the address is stored.
In the end, I want all of the data from the last form to be stored in a new table. Any opinions?
Thanks