Moving a record once it has been completed

[sthapa]

Hi All

is there a way to move a record to another table once certains fields on a form have been completed.
Also once the record has been moved it is there any way of deleting it from the original table ?

Thanks

 

[Mile-O]

Use an APPEND Query and then use a DELETE Query