how do I do this??

[marf]

I have a Projects Database with several tables. The main table, TblProjects,
contains all the main details about a project, including the status (open,
on-hold, completed, cancelled, etc).

I have a form that pages through each record where the users can
update/enter information regarding the project. When the status of a project
changes from Open to Closed, I would like for that project no longer to show
up as a record when I open the main form.

In other words, let's say I have 10 projects on the table, when I open the
main form I can page through the 10 records, update them, etc. Now I change
project #1 to status = closed. When I open the form again, I only want to see
and page through the remaining 9 projects that are still open. I don't want
to delete the 'closed' project.

How can I do this??

Thanks

 

[Arvin Meyer [MVP]]

Change the recordsource of your form to a query which has the criteria in
the Status column set to:

<> "Closed"