Tabbed form setup

[google3luo359]

In a form that has tabs, with each tab having a form with its subform,
should the tabs' form/subforms have distinct names from the other tabs'
form/subform names?

I'm asking as each tab's form/subform will be pulling up data from the
same table.
You may ask, why have tabs then?
Simply to have a visual tab showing that the data is from a different
group within the table.

Thanks very much! Ric

 

[Allen Browne]

No. The different subforms can have the same field/control names. There is
no need to alias them.

It is not uncommon to create a data structure where one related table
contains types of items that a user would conceive of as different, so you
interface them with different forms or subforms. For example, a work order
might contain parts and labour that are all stored in the one table, but are
shown in different subforms.

If a subform has the same source table as the main form, you are likely to
run into problems though. The problem is not a naming clash, but the way the
main form and subform are linked through the
LinkMasterFields/LinkChildFields. You can actually mess up an AutoNumber
with this kind of form, as mentioned in this article:
http://allenbrowne.com/ser-40.html