How to set the RecordsetType for a subform OnOpen of the main form?

[sueb]

ADezii helped me with this once, but I must have messed it up somehow and can't figure it out again!

All my forms are opened either in Dynaset or Snapshot mode, depending on whether the user has put in the correct password. One of my forms (Patient_IUR_Ov erview) has a subform (IURs_Abbreviat ed_subform), and I had the following code in the main form's OnOpen event, which was working great:

Private Sub Form_Open(Cancel As Integer)
    If ReadOnly Then
        Me![IURs_Abbreviated_subform].Form.RecordsetType = conSnapshot
        Me![Add_New_Chart].Visible = no
    Else
        Me![IURs_Abbreviated_subform].Form.RecordsetType = conDynaset
    End If
End Sub
 

Now, however, I'm getting an error that says it can't find "the field" IURs_Abbreviate d_subform. It didn't used to think this name was a field, but correctly recognized it as the name of the subform (the control and the subform itself have the same name).

I'd made some changes before I began to see this error, but couldn't identify what caused this. I'm uploading my front end and some dummy data. The password can be found in the Passwords module; the trouble comes when selecting "Pre-Admitting" (from the main menu), and then "Patient / IUR Overview" from the next menu.

Thanks to anyone who can help me with this!

[ADezii]

Try:

Private Sub Form_Open(Cancel As Integer)
  If ReadOnly Then
    Me![IURs_Overview].Form.RecordsetType = conSnapshot
      Me![Add_New_Chart].Visible = False
  Else
      Me![IURs_Overview].Form.RecordsetType = conDynaset
  End If
End Sub

[sueb]

That did it, ADezii!

What do you think it is in my mental model that is keeping me from being good with this? I have a pretty good understanding of points and attributes and all that kind of stuff, but in other languages. I just can't seem to get a firm grip on Access/VBA's underlying structure. I don't suppose you could recommend a decent language manual, could you? You know, one that assumes you already know how to design stuff, but just need the vocabulary, etc. for Access/VBA...

Anyway, thanks again for coming to my rescue!

[ADezii]

There are many good references out there, sueb, and I really don't know if any one is better than the other. One thing that I can tell you is that your recent problems revolve around differentiating between an actual Sub-Form, and the Sub-Form Control that actually contains the Sub-Form. These are not one and the same thing. There are actually few instances where you would be addressing the Sub-Form itself by name, usually it will be the Control containing it. Learning the difference between the two would be a good starting point. Good Luck.

P.S. - As far as VBA goes, you cannot conceivably know details on every Property, Method, Event, Syntax, etc. on Components. The key, at least for me, if to know which Property, Method, Event, etc. is applicable in any given situation. Looking up the correct Syntax, then, is a simple matter since the Help Files are pretty much comprehensive in most cases.

[sueb]

That's very helpful, ADezii, and is just the sort of thing I need. I don't expect to know details for everything; I'd just like to be able to know what "element" I need to be researching. That's what I meant by understanding the underlying structure. Thanks again!