microsoft.public.access.forms

Hi,

I would like to a move record from my main table/form once that person's
file has been completed and store it in a closed table. How do I do this (if
it can be done)?

I was hoping that it can be done utiling a check box on the form where I
would check the box once the record is closed and that check will cause to
record to be moved to a closed table. Thanks a bunch!