H
h2o4001
Hello.
I have 6 Tables, all with identical fields. I want to copy a record
from one table into another table, which table depends on what table
is selected in a form. So if the table names are One, Two, Three,
Four, Five, Six, and the record that I want to copy and insert into
another table has been selected by a query in a form. I want the form
to direct where to insert the table. So if the form has table Two
selected (from the drop down list) then it should insert the record
into table Two. If the form has table Four selected then it should
insert it into table Four. The table the record is currently listed in
is not listed in the form's drop down list.
Any suggestions? Oh, I don't know VBA, so if you give me VBA code to
do it, please highlight where I need to make changes (ie rename
tables, forms, form fields, etc...)
Thanks!
I have 6 Tables, all with identical fields. I want to copy a record
from one table into another table, which table depends on what table
is selected in a form. So if the table names are One, Two, Three,
Four, Five, Six, and the record that I want to copy and insert into
another table has been selected by a query in a form. I want the form
to direct where to insert the table. So if the form has table Two
selected (from the drop down list) then it should insert the record
into table Two. If the form has table Four selected then it should
insert it into table Four. The table the record is currently listed in
is not listed in the form's drop down list.
Any suggestions? Oh, I don't know VBA, so if you give me VBA code to
do it, please highlight where I need to make changes (ie rename
tables, forms, form fields, etc...)
Thanks!