Trying To Reference SubForm: "2467 Object closed or does not exist"?

>So it seems like it sort of exists, but doesn't exist.... depending on what
>props I try to get to.

>I've got a parent form and three subforms.
>
>Two of them work A-OK.
>
>For the third one, in the Immediate window:
>-----------------------------------------
>?Me.subDeal.Name
subDeal
>
>?Me.subDeal.SourceObject
frmDeal_Deal
>
>?Me.subDeal.RecordSource
2467 - Object closed or does not exist
>-----------------------------------------

>
>So it seems like it sort of exists, but doesn't exist.... depending on what
>props I try to get to.
>
>Tried SaveAsText and then LoadFromText, but nothing changed.
>
>I recall similar situations years ago and hazily recall that in one of them it
>was something to with not having any records behind the subform... but I've got
>a dummy table there... (I think.... because I can't check it in Immediate or
>in code).
>
>Anybody been here?

>?Me.subDeal.Form.Recordsource
>
>Recordsource is a property of the form contained in the subform control, not of
>the subform control itself.

>Per Wayne Gillespie:>
>I mis-typed in the post.
>
>Here's a Copy/Paste from the actual VBA:
>---------------------------------------------
>9020 With Me
>9021 .subDeal.Form.RecordSource = ""
>9022 .subMetrics.Form.RecordSource = ""
>9023 .subPaymentHistory.Form.RecordSource = ""
>9024 .subPriceHistory.Form.RecordSource = ""
>9025 .subTranche.Form.RecordSource = ""
>9029 End With
>
>9030 WorkTable_Create "ttblDealCache_Deal", "zmtblDealCache_Deal"
>9031 WorkTable_Create "ttblDealCache_MetricHistory",
>"zmtblDealCache_MetricHistory"
>9032 WorkTable_Create "ttblDealCache_PaymentHistory",
>"zmtblDealCache_PaymentHistory"
>9033 WorkTable_Create "ttblDealCache_PriceHistory",
>"zmtblDealCache_PriceHistory"
>9034 WorkTable_Create "ttblDealCache_Tranche", "zmtblDealCache_Tranche"
>9039 WorkTable_Create "ttblDealCache_TrancheFund", "zmtblDealCache_TrancheFund"
>
>9040 With Me
>9041 .subDeal.Form.RecordSource = "ttblDealCache_Deal"
>9042 .subMetrics.Form.RecordSource = "qryDeal_MetricHistory"
>9043 .subPaymentHistory.Form.RecordSource = "qryDeal_PaymentHistory"
>9044 .subPriceHistory.Form.RecordSource = "qryDeal_PriceHistory"
>9045 .subTranche.Form.RecordSource = "qryDeal_Tranche"
>9049 End With
>---------------------------------------------
>
>To me, the puzzler is why .subDeal fails and the other four work.
>
>I *know* I've been here before but cannot remember what the cause was.

>
>Have you tried making the recordsource of .subDeal a query instead of the table?
>I have no idea why this would make a difference, but it is the only difference I
>can see between the 5 calls.