Question about tab controls

[marf]

I read somewhere (but I can't find it again) that you should not put form
controls on the main tab page, because they would show in every record or
something like that, is it true?

I am planning on having 1 "big" tab control, where the main page is the main
form, and every other tab is a subform. Does anyone see any issues with this
design???

Thanks

 

[Wayne-I-M]

Hi

The subforms are not the tabs - they go in the tabs

I read somewhere (but I can't find it again) that you should not put form
controls on the main tab page, because they would show in every record or
something like that, is it true?

Not sure what you mean by this.
You have a main form (for example) to show the details of people
Tab1 may show the various address of the person
Tab2 may show the bills paid by the person which in the house selected on
tab1
etc

So yes you need to have at least one control on the main form - the primary
field to link the subform(s) althoug the subforms may not all be linked
directly to the main form but to other subforms. It depends on the layout of
your form(s)

But just 1 control would be a little strange - unless there is a good reason
for it

 

[marf]

Wayne,

Let me explain my issue a little better...

I have a TblProjects that contains all details about a project. I created a
form based on this table. I also have a table that contains the approvers for
this project, I also created a form for this table. The relationship of the
tables is one-one based on the Project Number, because for each project there
is only 1 set of approvers.

I need to create a "main form" using tabs where the main tab contains
TblProjectsFrm and the 2nd tab contains TblApproversFrm.

This is the problem that I run into:

The 1st tab looks fine, I can see the information of each record as I click
through them, however, the 2nd tab, always shows the 1st record of the 2nd
table. I need to make sure that the 2nd tab only shows the record associated
with the project selected on the 1st tab.... I hope that makes sense

 

[Wayne-I-M]

Your main form should be TblProjectsFrm
with a subform of TblApproversFrm

If you only have 2 forms it seems a bit strange to use any tabs

Just create TblProjectsFrm
Then insert a subform TblApproversFrm
Link them with Project Number (ensure this is held in a control on each form)