I just inherited a database from someone who quit. it's a workflow database built off of a document library template from version 5 or 6.
I'm trying to prevent saving if the document is in an approved state (status = 3), and i've been running around in circles.
i updated the QuerySave event to include :
If note.Status(0) = "3" Then note.SaveOptions(0) = "1" Else note.SaveOptions(0) = "0"
There are a series of : note.RemoveItem("SaveOptio
ns") statements in the QueryOpen and QuerySave events that I think is preventing my logic from working, but when I comment it out, users receive a "linked document cannot be found in the view" error.
the basic program flow is this : originator creates a document, sends for review. reviewer approves the document ( button has formula language to set status to 3, send doclink to originator)
once the approver approves the document...( sets status to 3) , i want to prevent editing to the document.
I attached a file with code from the queryopen, querysave and the approval button logic.
any help is appreciated. thanks!