Capture data from query/form and update another table

[Josh_Brainard]

I have built a query that put its results into a form where you can edit the
data in that table. Pretty standard.

I would like to capture all of those fields in the form that the query
returns as well as some addtional ones and insert them into another table for
tracking and reporting purposes.

I am not exactly an access genius (I try hard) and I really couldn't find
anything out of the box(read 'with a wizard') that would accomplish this.

Can anyone help or possibly guide me to somewhere that can?

Thanks

 

[Mr. B]

Josh,

If the two tables can be "related" then you can add fields from the second
table and have all of the fields available for your form.

If you cannot do that, then you can add unbound controls to the form and
when the user is finished providing the data you would then have to
programmatically collect the data from the unbound controls and use an Insert
type sql statement to add the data to the appropriate table.