More Secure Way To Prevent Edit Mode Based On Doc Status

If you want to prevent a document from being edited based upon a status. Put
the following code into the QueryModeChange event of the form. The
QueryModeChange even happens just before the current document mode changes. In
this case there are 6 different status' : New, Submitted, Reviewed, Approved,
Rejected and Paid. If the document is in any status except Rejected and Paid
the document may be edited. If it is in Paid or Rejected... edit mode will not
be allowed. This is a little more secure because it doesn't allow people who
can create their own views to bypass this.
Sub Querymodechange(Source As Notesuidocument, Continue As Variant)
Dim status As String
Dim status1(3) As String
Dim i As Integer
status = Source.FieldGetText("status")

status1(0) = "New"
status1(1) = "Submitted"
status1(2) = "Reviewed"
status1(3) = "Approved"

For i = 0 To 3
If status1(i) = status Then
' allow edit mode
Continue = True
Exit Sub
End If
Next i
' do not allow into edit mode
Continue = False
End Sub

This was first published in November 2000

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Back to top