Karl,
I didn't create queries in this form. Furthermore, my knowledge of such is
nill to none :-( sorry. Can you ellaborate? Thanks.
Ellie
"KARL DEWEY" wrote:
> 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!
> >
> >