microsoft.public.access.forms

Better than actually moving the record is to use the checkbox to archive the
record in the same table. Add criteria to your queries to only pull records
that are not archived.
--
KARL DEWEY
Build a little - Test a little


"Ellie" wrote:

> 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!
>
>