更新时间:2022-11-28 11:34:12
Mike,
这些选项非常无限.....我有一些带有五个标签的表格,一个标签上有四个子表格....所有指向不同的表/查询。您有什么想法?
Mike,
The options are pretty limitless..... I''ve had some forms with five tabs, and four subforms on a tab.... All pointing to different tables/queries. What do you have in mind?
根据我的发现,限制是7个级别的子表单,754个控件/部分在表单的生命周期内。 (限制子表单?)标签除了视觉上,控制对子窗体没有任何影响。我做了一个有5个子表格的数据库,所以你的三个应该没问题。
更新:我刚发现一篇文章给出了更好的限制:子表单
From what I have found, the limit is 7 levels of subforms, 754 controls/sections over the life of the form. (Limit for subforms?) The tab control doesn''t really have any effect on the subform other than visually. I have done a database that had 5 subforms, so your three should be okay.
Update: I just found an article that gives better limitations: Subforms
嘿twinnyfo,
Page1:Record Source = tblIntakeMaster
链接字段:IntakeMasterID(tblIntakeMaster的PK)
Page2:记录源(tblClient)= sfrmClient
链接字段:ClientID(tblClient的PK)
Page3:记录来源(tblAccident)= sfrmAccident
链接字段:意外ID(PK为tblAccident)
Page3 :记录来源(tblFollowUp)= sfrmFollowUp
链接字段:FollowUpID(tblFollowUp的PK)
基本上我认为是它。看起来我的Link Field正在消失,或者当我把它放回去时,我在该页面上的Subform消失了。我不确定为什么?
谢谢,
Mike
Hey twinnyfo,
Page1: Record Source = tblIntakeMaster
Link Field: IntakeMasterID (PK for tblIntakeMaster)
Page2: Record Source (tblClient) = sfrmClient
Link Field: ClientID (PK for tblClient)
Page3: Record Source (tblAccident) = sfrmAccident
Link Field: AccidentID (PK for tblAccident)
Page3: Record Source (tblFollowUp) = sfrmFollowUp
Link Field: FollowUpID (PK for tblFollowUp)
Basically I think that is it. It seems like either my Link Field is disappearing or when I put it back, my Subform on that Page disappears. I''m not really sure why?
Thanks,
Mike