表格问题 [英] Question on Forms

问题描述

我知道您可以拥有一个包含多个页面（标签）的表单。我也明白你可以让Page2的子窗体指向不同的表。我在第2页看到你可以拥有2个子表格。


那么，你能在第2页上拥有超过2个子表格吗？


和你有一个Page3与另一个Subform指向不同的表吗？


谢谢，

Mike

I get that you can have a Form with multiple Pages (tabs). I also understand that you can have Page2 with a Subform pointing to a different table. And I see that on Page2, you can have 2 Subforms.

So, can you have more than 2 Subforms on Page2?

And can you have a Page3 with another Subform pointing to a different table?

Thanks,
Mike

推荐答案

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

这篇关于表格问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！