Opening form as Read-Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
I have a form that gives the users a menu of command buttons to open other
forms.
One option is to open and have full edit ability to the "Claim Master" form.
Some users should not be able to change the records on the "Claim Master"
form but require read-only capabilities. I would like to have a command
button on the initial form that opens the "Claim Master" in read-only.
What's the best way? Also, the "Claim Master" form has a subform. Does the
command button need to do anything to make this read-only as well?

Thanks in Advance,
Paul
 
On the OpenForm command line add the argument that specified that the form
will be open for read only (acFormReadOnly)

Docmd.OpenForm "111",,,,acFormReadOnly
 
Think I figured it out, seems to work anyways. I used the button wizard to
open the form and then went in and adjusted the code by adding the
acFormReadOnly. Anyone see any problems/concerns with this?

Private Sub OpenClaimMasterForPHS_Click()
On Error GoTo Err_OpenClaimMasterForPHS_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Claim Master"
DoCmd.OpenForm stDocName, , , , acFormReadOnly, , stLinkCriteria

Exit_OpenClaimMasterForPHS_Click:
Exit Sub

Err_OpenClaimMasterForPHS_Click:
MsgBox Err.Description
Resume Exit_OpenClaimMasterForPHS_Click

End Sub
 
Back
Top