ReadOnly Function

  • Thread starter Thread starter Matt Howard
  • Start date Start date
M

Matt Howard

I am using the DoCmd.OpenForm in my code and the
acFormReadOnly property is not working. When my form
opens, all the data is editable.

Any suggestions?

TIA,

Matt Howard
 
Matt Howard said:
I am using the DoCmd.OpenForm in my code and the
acFormReadOnly property is not working. When my form
opens, all the data is editable.

Any suggestions?

TIA,

Matt Howard
Click to expand...

Please post the exact code you're using. Is there any code behind the
form that mya be altering its properties?
 
Sorry, I realized that I should've in the orignal post.

Here is my code:

Private Sub FindRecord_Click()
DoCmd.OpenForm "frmRetrieve", acNormal, , ,
acFormReadOnly, acWindowNormal
MsgBox "This information is Confidential",
48, "Confidential"
End Sub

My problem is that frmRetrieve is not the form I want to
use. I have another form that is exactly the same as
frmRetrieve called "frmDriverInfo", same fields, etc.
frmDriverInfo needs to be read-only and is opening as
edit. The properties of the forms both have AllowEdits,
AllowAdditions, AllowDeletions as True and DataEntry as
False. I have tried altering all of the properties and
still no success.

I appreciate the help.

Matt
 
Matt Howard said:
Sorry, I realized that I should've in the orignal post.

Here is my code:

Private Sub FindRecord_Click()
DoCmd.OpenForm "frmRetrieve", acNormal, , ,
acFormReadOnly, acWindowNormal
MsgBox "This information is Confidential",
48, "Confidential"
End Sub

My problem is that frmRetrieve is not the form I want to
use. I have another form that is exactly the same as
frmRetrieve called "frmDriverInfo", same fields, etc.
frmDriverInfo needs to be read-only and is opening as
edit. The properties of the forms both have AllowEdits,
AllowAdditions, AllowDeletions as True and DataEntry as
False. I have tried altering all of the properties and
still no success.

I appreciate the help.

Matt
Click to expand...

I'm still not sure I understand. Did you try

DoCmd.OpenForm "frmDriverInfo", acNormal, , , acFormReadOnly

? At the moment I can't think of any reason why that wouldn't work.
 
Back
Top