Transfer Query Info. To Table

I am using MS Access 2000. I created a union query from two tables. I am using the union query to bring up individual records in a form based on a certain criteria (Ex: [By Serial #]). I need to put three additional fields on the form so that the user can add information to the record from the query then save the record to an existing third table. The existing third table will have all the fields from the union query including the three additional fields on the form. I have two questions:

What is the best way to handle these three additional fields (properties, table link, etc.) on the form since the three fields will only exist in the third table and the record will be saved to the third existing table?

I will need to save the record one at a time from the form to the third existing table after data is entered into the three additional fields. I was thinking a command button on the form that runs a macro to save the record from the query along with info. added to the additional fields. I don’t know how to write such a macro or if this would be the best way to perform this function?

Thanks in advance.

To start with, DON'T DO THAT! ;-) It is BAD database design to store the
same data in multiple tables. Use your Union Query as the basis of a Make
Table Query, then open the new table in design view and add the 3 new
fields. Then use that table as the Record source for your form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdeisgns.com/Security.htm


"Delano" wrote in message
...
I am using MS Access 2000. I created a union query from two tables. I am
using the union query to bring up individual records in a form based on a
certain criteria (Ex: [By Serial #]). I need to put three additional fields
on the form so that the user can add information to the record from the
query then save the record to an existing third table. The existing third
table will have all the fields from the union query including the three
additional fields on the form. I have two questions:

What is the best way to handle these three additional fields (properties,
table link, etc.) on the form since the three fields will only exist in the
third table and the record will be saved to the third existing table?

I will need to save the record one at a time from the form to the third
existing table after data is entered into the three additional fields. I
was thinking a command button on the form that runs a macro to save the
record from the query along with info. added to the additional fields. I
don't know how to write such a macro or if this would be the best way to
perform this function?

Thanks in advance.