Edit / No Edit in VBA

[mredmond]

I have a form that I have created with a Tabstrip and a large Unbound subform control. Depending on which button on which tab is selected, different forms are bound to the Unbound control using VBA. No problems there.

A series of other buttons (not part of the Tabstrip) appear / disappear based on which form is displayed in the subform control. Again, no problems.

Here's the issue: When I display a list of open projects and the user selects one of them, he/she can then press an EDIT button or a DETAILS button. Logically, I don't want to user to be able to edit the data in the DETAILS screen, but I DO want them to be able to edit in the EDIT screen. I have implemented this by having 2 identical forms, one with ALLOW EDIT = TRUE and one with ALLOW EDITS = FALSE.

Is there a way to do this with a single form, using VBA to change the ALLOW EDITS attribute? I have not been able to get my addressing right.

The subform is simply named DisplayArea. I assign the particular form with:
DisplayArea.SourceObject = "Project List" or
DisplayArea.SourceObject = Project List - Edit"

I've tried the following and none work:
DisplayArea.AllowEdits = true
"Project List".AllowEdits = true
[Forms]![Project List].AllowEdits = true

I'm sure this can be done, but I'm missing something in the syntax.

Thanks for the assist.

 

[mredmond]

To anyone interested -- I just answered my own question.
The proper syntax, given the info above, is:

DisplayArea.Form.AllowEdits = True

It worked like a charm.

 

[Rich]

Forms!MainFormName!SubFormControlName.AllowEdits = False

 

[mredmond]

Thanks Rich!