how to pull a record to a form and save it to a diffrent table

  • Thread starter Thread starter Lorraine
  • Start date Start date
L

Lorraine

hi,
I want to pull data from more then one field ( as it seems with a combo
box with multiple fields listed in a row ) and have it save these fields to a
diffrent table. What I'm trying to do is take a Whole record and save that
record to a new table.

Thanks
L
 
Why?
It is not necessary to store redundant data. It is, in fact, a database
design fault. If you can describe your objective, perhaps we could offer an
alternative solution.

But, in any case, unless you need to see the original record first, there is
no need for a form.
 
it's unusual to store identical records in two tables, or to move records
from one table to another. can you tell us what you're trying to accomplish
by doing this? perhaps someone can suggest a better solution.

hth
 
Back
Top