Close and move record

E

Ellie

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

KARL DEWEY

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.
 
E

Ellie

Karl,

I didn't create queries in this form. Furthermore, my knowledge of such is
nill to none :-( sorry. Can you ellaborate? Thanks.

Ellie
 
K

KARL DEWEY

Add a Yes/No field to your table and bind the checkbox of the form to it.
The condition of a Yes/No is stored as -1 (minus one) for Yes and 0 (zero)
for No.
Open your query in design view and double click on the Yes/No field name in
the displayed table field list. It will be added ti the field row of the
query. For only active records enter a 0 (zero) in the criteria row of the
grid. For all records use no criteria. For archived records only use a -1
(minus one).
 
Top