MS Access Copy record to another table based on a form input

[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!

 

[tina]

six identical tables almost guarantees that you're storing data in table
names, which violates normalization rules. suggest you STOP, and read up on
relational design principles. then examine your tables/relationships
structure and correct it where necessary, before moving on to queries,
forms, etc. for more information, see
http://home.att.net/~california.db/tips.html#aTip1.

hth