Transfer Query Info. To Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
I am using MS Access 2000. I created a union query from two tables. I am
Click to expand...
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,
Click to expand...
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
Click to expand...
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?
 
Back
Top