Sub-SubForm参考问题 [英] Sub-SubForm Reference Problem
问题描述
我有一个表单（frmDeal）有一个子表单（frmDeal_Tranche），它有一个
子表单（frmDeal_TrancheCusip）。
当我尝试引用Cusip上的属性。表格在链的末尾，
MS Access正在抛出2455：表达式对财产的无效引用
表格/报告
在立即窗口中：
------------------------------------- -----
？me.Name
frmDeal
？me.subTranche.Form.Name
frmDeal_Tranche
？me.subTranche.Form！subCusips.name
subCusips
？me .subTranche.Form！subCusips.SourceObject
frmDeal_TrancheCusip
？me.subTranche.Form！SubCusips.Form.name
（ 2455：表达式对财产表格/报表的引用无效）
--------------------------- ---------------
我是否试图将MS Access推向远处？
或我只做一些简单而愚蠢的事情吗？
-
PeteCresswell
（PeteCresswell）写道：
我有一个表单（frmDeal）有一个子表单（frmDeal_Tranche），它有一个
子表单（frmDeal_TrancheCusip）。
当我尝试引用时对于Cusip的属性表格在链的末尾，
MS Access正在抛出2455：表达式对财产的无效引用
表格/报告
在立即窗口中：
--------------------------------- ---------
？me.Name
frmDeal
？me.subTranche.Form.Name
frmDeal_Tranche
？me.subTranche.Form！subCusips.name
subCusips
？me.subTranche.Form！subCusips.SourceObject
frmDeal_TrancheCusip
？me.subTranche.Form！SubCusips.Form.name
（2455：表达式对财产表格/报告的引用无效）
----------------------- -------------------
我是否想把MS Access推向远方？
或者我只做一些简单而愚蠢的事情？
除了我没看到你如何获得
a参考即时窗口中的表格，以便
我可以工作，这应该可以工作。
你已经和第四个电话一样深了
一起去第五个就子范式而言。至于
对象去DAO比那更深。
你有没有尝试过Fairfield先生的建议
跳过点击你的方式通过层次结构
并且只使用：Form_frmDeal_TrancheCusip.Name？
blockquote>
在Sun，03 2006年9月14日28:02 - 0400，（PeteCresswell） < x@y.Invalid>
写道：
>我有一个表格（frmDeal）有一个子表格（frmDeal_Tranche）有一个
子表单（frmDeal_TrancheCusip）。
当我尝试引用Cusip上的属性时链接末尾的表单，
MS Access正在抛出2455：表达式无效引用属性
表单/报告
在立即窗口中：
------------------------------------------
？我。姓名
frmDeal
？me.subTranche.Form.Name
frmDeal_Tranche
？me.subTranche.Form！subCusips.name
subCusips
？me.subTranche.Form！subCusips.SourceObject
frmDeal_TrancheCusip
？me.subTranche.Form！SubCusips.Form.name
（" 2455：表达式对财产表格/报告的无效引用）
--------------------------------- ---------
我是不是想把MS Access推向远方？
或者我只是做一些简单而愚蠢的事情？
也许这是特定版本的东西？我刚用Access 2000在我的
即时窗口中运行了这个：
？me.Name
frmDeal
？me.subTranche.Form.Name
frmDeal_Tranche
？me.subTranche.Form！subCusips.name
subCusips
？me.subTranche.Form！subCusips.SourceObject
frmDeal_TrancheCusip
？me.subTranche.Form ！SubCusips.Form.name
frmDeal_TrancheCusip
- = - = - = - = - = - = - = - = - = - = - = - =
Randy Harris
tech at promail dot com
Per rkc：
>除了我没有看到你如何获得
在即时窗口中对表单的引用这一事实，以便
我工作，这应该工作。
我在加载表单的过程中停止了代码。
好抓。我会回去尝试从表单外部复制它 -
知道如果.RecordSource后面没有记录，MS Access可以
抛出一个错误之类的东西（不确定它是否完全相同）我发布的那个。
-
PeteCresswell
I''ve got a form (frmDeal) that has a subform (frmDeal_Tranche) that has a
subform (frmDeal_TrancheCusip).
When I try to refer to properties on the "Cusip" form at the end of the chain,
MS Access is throwing "2455: Expression has invalid reference to Property
Form/Report"
In an Immediate window:
------------------------------------------
?me.Name
frmDeal
?me.subTranche.Form.Name
frmDeal_Tranche
?me.subTranche.Form!subCusips.name
subCusips
?me.subTranche.Form!subCusips.SourceObject
frmDeal_TrancheCusip
?me.subTranche.Form!SubCusips.Form.name
("2455: Expression has invalid reference to Property Form/Report")
------------------------------------------
Am I trying to push MS Access to far?
Or am I just doing something simple-and-dumb?
--
PeteCresswell解决方案(PeteCresswell) wrote:I''ve got a form (frmDeal) that has a subform (frmDeal_Tranche) that has a
subform (frmDeal_TrancheCusip).
When I try to refer to properties on the "Cusip" form at the end of the chain,
MS Access is throwing "2455: Expression has invalid reference to Property
Form/Report"
In an Immediate window:
------------------------------------------
?me.Name
frmDeal
?me.subTranche.Form.Name
frmDeal_Tranche
?me.subTranche.Form!subCusips.name
subCusips
?me.subTranche.Form!subCusips.SourceObject
frmDeal_TrancheCusip
?me.subTranche.Form!SubCusips.Form.name
("2455: Expression has invalid reference to Property Form/Report")
------------------------------------------
Am I trying to push MS Access to far?
Or am I just doing something simple-and-dumb?Aside from the fact that I don''t see how you are getting
a reference to the form in the immediate window so that
Me works at all, that should work.
You are already as deep with the forth call as you are
going with the fifth as far as subForms go. As far as
objects go DAO is deeper than that.
Have you tried Mr. Fairfield''s recommendation of
skipping dotting your way through the hierarchy
and just using: Form_frmDeal_TrancheCusip.Name?
On Sun, 03 Sep 2006 14:28:21 -0400, "(PeteCresswell)" <x@y.Invalid>
wrote:
>I''ve got a form (frmDeal) that has a subform (frmDeal_Tranche) that has a
subform (frmDeal_TrancheCusip).
When I try to refer to properties on the "Cusip" form at the end of the chain,
MS Access is throwing "2455: Expression has invalid reference to Property
Form/Report"
In an Immediate window:
------------------------------------------
?me.Name
frmDeal
?me.subTranche.Form.Name
frmDeal_Tranche
?me.subTranche.Form!subCusips.name
subCusips
?me.subTranche.Form!subCusips.SourceObject
frmDeal_TrancheCusip
?me.subTranche.Form!SubCusips.Form.name
("2455: Expression has invalid reference to Property Form/Report")
------------------------------------------
Am I trying to push MS Access to far?
Or am I just doing something simple-and-dumb?Perhaps it''s something version specific? I just ran this in my
immediate window with Access 2000:
?me.Name
frmDeal
?me.subTranche.Form.Name
frmDeal_Tranche
?me.subTranche.Form!subCusips.name
subCusips
?me.subTranche.Form!subCusips.SourceObject
frmDeal_TrancheCusip
?me.subTranche.Form!SubCusips.Form.name
frmDeal_TrancheCusip
-=-=-=-=-=-=-=-=-=-=-=-=
Randy Harris
tech at promail dot com
Per rkc:>Aside from the fact that I don''t see how you are getting
a reference to the form in the immediate window so that
Me works at all, that should work.I stopped the code during the process of loading the form.
Good catch. I''ll go back and try to replicate it from outside of the form -
knowing that if there are no records behind a .RecordSource that MS Access can
throw an error something like (not sure if it''s exactly the same) the one I
posted.
--
PeteCresswell
这篇关于Sub-SubForm参考问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
