Hello gang:

I'm looking to acheive the following and would appreciate any suggestions.

My current database has a main screen which shows all current years records. When a record is completed it is labeled as closed (check box being checked) and or a field with a drop down box which has closed, pending etc listed).

I am looking to be able to exclude or hide all closed records from the main screen when the database is opened. Not sure how to accomplish this.

Bryan

My current database has a main screen which shows all current years records.

Not 100% sure what your setup is here. Are you using a portal or just showing the actual records.

If its a regular set of records and it is already only showing only the current years records, then there is already a script that has some kind of find criteria as part of the opening script.

So you can modify it to something like:

Enter Find Mode []

Set Field [ YourDate; Date ( 1; 1; Year ( Get ( CurrentDate ) - 1 )

New Record / Request

Set Field [ Status; "Closed" ]

Omit Record []

Perform Find []

John:

Thank you for the reply that works they way I'm looking.

Out of curiosity how or what would I add to exclude additional records by status (example we have records that are closed, unfound, pending) I have the script set now to exclude closed how can I also exclude unfound at the same time?

Thank you

Opieos

Just add before your perform find.

New Record / Request

Set Field [ Status; "unfound" ]

Omit Record []