Typically, our databases were created with the following Lotus Script in the Querymodechange:
Sub Querymodechange(Source As Notesuidocument, Continue As Variant)
Dim doc As notesdocument
Dim session As New notessession
If(doc.GetItemValue("status")(0) <>"Draft" And "Sue Smith" <> session.CommonUserName) Then
Messagebox "Once submitted this document cannot be edited.", 64, "Help"
Although I am not saavy or experienced enough to know exactly how to write Lotus Script, I do know that this code locks down a form so that a user can not edit it once it leaves draft. However, an administrator like Sue Smith can.
I'd like to take this down to the field level so that instead of locking down the whole form, I can lock down some fields, but leave others open for editing - such as the field that allows for attachments. Although we do not want the document edited once submitted, we do still want the user to be able to attach additional documentation.
Any suggestions would be much appreciated.