Access can't find a sub-form

[GraeagleBill]

I have a Form that includes a Sub-Form. I want to reference one of the fields within the RecordSource of the Sub-Form. Within the code-sheet of the Form, a Public Function is called via a right-click popup menu. A snippet screenshot (below) of the "open" Sub-Form is shown with the record-selector highlighted on the record of interest.





The following code produced the error shown above: (Note: "FamilyDetailsSubform" is the name of the Sub-Form, NOT the container control.)

Public Function DelPseudoMbr()
Dim lngFormRec As Long

lngFormRec = Forms!FamilyDetailsSubform.Form!RegistryID

Debug.Print lngFormRec
End Function

The Sub-Form is obviously Open so that's not the issue. While query/table field "RegistryID" is not bound within the Sub-Form, I don't think Access got that far anyway so I don't believe that's an issue.
Am I missing something in the syntax of the failing assignment statement?

[pbaldy]

You need to include the main form in the reference:

http://theaccessweb.com/forms/frm0031.htm

[GraeagleBill]

Forms!FamilyDetails!FamilyDetailsSubform.Form!Regi stryID (I bookmarked your reference. Surprised it didn't pop up when I Googled the issue before posting.)

BINGO!

[pbaldy]

I was going to yank your chain but figured all the snow had gone to your head.

[GraeagleBill]

How embarrassing! The genesis of the form and its module is mid-Office97, my very early days in Access to say the least. However, after applying your fix and progressing to other items of concern in the module I found another statement from yesteryear that was coded correctly and has been executing successfully for years. See, I told you I CRS!

[pbaldy]

I battle that disease myself.