Save Records to different table

[Guest]

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.

 

[Douglas J. Steele]

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?

 

[Guest]

Thanks for getting back too me, can please give me the steps how to do that
plz.

 

[Douglas J. Steele]

Assuming you've got a field named Status in your table, in the form's
BeforeUpdate event, put code that checks whether all of the necessary fields
are complete or not. If they are, set Status = True. Otherwise, set Status =
False.