Previous Thread

6/30/2006 1:51:01 AM    Save Records to different table
Hi 
 
I have this database, i am goign to make it as simple as i can. 
 
I have created  two tables( table 1, table 2) then query then two forms( 
 
from1, form2), so when some one fill form (form1) he does not fill the whole 
 
the form he just fill few feilds then press send but what i want to happen is 
 
when he press send the record will move to different table which is table 2, 
 
I have made another form which base on (table2) that have combo box that will 
 
be list all the records had been send from (form1) and when he select record 
 
then all the detail will show up and fill the rest and save it. 
 
Ok my question is how to Move or Copy  records from table to table?plz help 
 
and thanks for all your help and i will be look forward to hear from u soon.



6/30/2006 6:54:54 AM    Re: Save Records to different table
Why do you want to do that? What's wrong with simply putting an indicator on 
 
the record that it's incomplete, and then having different queries against 
 
table1 so one query returns all the complete records, while another query 
 
returns all the incomplete records? 
 
-- 
 
Doug Steele, Microsoft Access MVP 
 
http://I.Am/DougSteele 
 
(no private e-mails, please) 
 
"Hassan Merzha" <HassanMerzha@discussions.microsoft.com> wrote in message 
 
news:56A87359-097B-496D-AB5C-2554B3C180B3@microsoft.com...