How to incorporate data collected from 3 existing forms into one table?

[Ron Bixler]

I am currently working in ACCESS 2007 and trying to incorporate data collected from 3 seperate forms into 1 unifying table. This will involve the inclusion of at least 1 single unifying field in each form so that as data is collected it is stored in the correct record. Data will not be gathered in any specific order for subsequent operations ie....form 2 and form 3. I guess the real question is simply how do you change the target storage location for an existing form?

[maxamis4]

The form itself has a data source option under properties. This points to a table. You have to find out where the forms are pointing.

Need more details regarding your form and the table where it is stored.

[Bruce Callander]

Are you using unbound forms (not linked to a particular table or query)? Also, will the data from Form A become a record on its own in the target table, or is the data from Form A to be combined with Form B/Form C before adding to the target table?