Hide Record from Search after it has been "locked"

[BrendaD]

I have an ASP UD web application where Security Officers fill out online forms to submit their reports.

After the reports are submitted, they are reviewed by their Supervisors and "locked" - they should not be able to go back and alter the records after they are "locked" due to legal, etc. reasons.

To make alterations, they need to submit a supplementary report.

The officers need to search for Open Records that Dispatch has started so they can finish and submit them BUT I need to be able to hide the record from the search after it has been submitted.

Any ideas? JavaScript, ASP code, VB Code?

Thanks, Brenda

 

[schase]

Hi Brenda,

Well it depends on how you submit the records now

If they go into a database, you can add a field call it fldLocked.

default value would be "no" or zero,

When you do an edit form (where the supervisors review) - put a hidden value of

<input type=&quot;hidden&quot; name=&quot;txtLocked&quot; value=&quot;yes&quot;>

For the update - which you update txtLocked into fldLocked.

After that, any display pages you simply filter out where fldLocked=&quot;no&quot;

That will only display those records.



&quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart