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
' do not allow into edit mode
Continue = False
This was first published in November 2000