Read-Only Form Can Be Edited Through Child Form

[BASSPU03]

I have a main form with two subforms whose underlying tables are related through one-to-many relationships. The forms function as follows:

frmFiscalYear > frmBulkObligati ons > sfrmProjects

I open frmFiscalYear in read-only mode (apparently this also affects the subforms, which is what I want) using the following code:

Private Sub cmdBOViewAll_Click()
On Error GoTo Err_cmdBOViewAll_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "frmFiscalYear"
    DoCmd.OpenForm stDocName, , , , acFormReadOnly
 
Exit_cmdBOViewAll_Click:
    Exit Sub
 
Err_cmdBOViewAll_Click:
    MsgBox Err.Description
    Resume Exit_cmdBOViewAll_Click
 
End Sub

sfrmProjects is a datasheet. I can double-click on the datasheet's records' selectors to open up a fourth form called frmViewAllResou rces. (This phenomenon was resolved here: http://www.thescripts. com/forum/thread741110.ht ml)

Problem: When I open frmFiscalYear (and its subforms) in read-only mode, it works fine. However, when I double-click the datasheet to open up frmViewAllResou rces, frmViewAllResou rces is editable and, upon closing, allows me to edit frmFiscalYear. Effectively, frmViewAllResou rces becomes a backdoor for editing when frmFiscalYear should be in read-only mode. Can the above code be modified to include frmViewAllResou rces as read-only, too?

Thanks in advance.

[MMcCarthy]

Firstly, to ensure that frmFiscalYear is read only when frmViewAllResou rces is closed then put the following line of code in the unload event of frmViewAllResou rces.

DoCmd.OpenForm "frmFiscalYear" , , , , acFormReadOnly

Even though the form is already open this should ensure it remains read only.

To ensure that frmViewAllResou rces is read only then you will have to change the openform code that opens this form to include the acFormReadOnly.

[veramitabh]

hi, I am facing similar problem. If the main form is set as "read only", is it possible not to let user click the button which will load the sub form?