ReadOnly Function

[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

 

[Dirk Goldgar]

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

Please post the exact code you're using. Is there any code behind the
form that mya be altering its properties?

 

[THDUNNCOXINTER.COM]

Please post the exact code you're using. Is there any code behind the
form that mya be altering its properties?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[THDUNNCOXINTER.COM]

Please post the exact code you're using. Is there any code behind the
form that mya be altering its properties?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Matt Howard]

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

 

[Dirk Goldgar]

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

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.