Hide a Record

[Guest]

I have a database that tracks the status of certain tasks. I would like to
be able to "close" a task using a drop down field on a form. After I close
the record, I would like to keep the record available to me (in case I need
to reference it later) but I don't want it to be one of the active records in
the database. In other words, if it is record one, when I open my form, I
should be able to close it and it should not show the next time I open the
form--it should show record two as record one. Does this make sense? I'm
sure I can create a macro to do this but I can't figure it out.

 

[Guest]

I have done this by setting the form's record source to a query. You can
then easily select specific criteria for which records you want to show. In
this case, have the query only show records with a "null" value for the date
closed, or something to that effect.