Append a table via a form?

[Deirdre]

Good afternoon.

I have a database which contains:
2 tables- Download and SOS (Download is updated daily via SQL macro from our AS-400)
Query: Qry_AS400 (Download is source)
Form: Frm_AS400 (Qry_AS400 is source)

The Qry_AS400 is used to select fields to autopopulate Frm_AS400 based on parameters selected by the user. Once the form is populated, the user is then to fill out additional fields which are not part of the Qry_AS400 source (Downlaod Table). I want the queried infomration PLUS the newly entered information to be saved to the SOS table.

I cannot save it to the Download table because it wuld disrupt the daily SQL macro that is used to update that table.

Your assistance is very much appreciated.

 

[bat17]

First idea that comes to mind is to treat the form like an unbound form and use code to append the data to the second table.

Second is to append the data directly from your download table to the SOS table and then bind the form to the SOS table.

Peter