Tabbed Form

[Khalil Handal]

Hi,
I have a form with three tabs, can the fields on each tab be from a
different table?
ie. three tabs , three sourse tables.

Khalil

 

[Guest]

Hi Khalil,

No. It is the form that is bound to the table or query, not the tab
control. Can you link your tables into a single query?

If not and you still want to do this then consider three separate sub forms
and toggle the visibility of these sub forms as if they were pages of a tab
control.

Rod

 

[Guest]

Yes you can as long as you put a subform on each tab. I have a database with
a main form and a tabcontrol with as of now about 7 tabs and each tab has a
subform that is link to the main form. You can also use the expression
builder to pull data from other tables or forms to display in a textbox on
each tab if you want.

Dan

 

[Khalil Handal]

Thank you both,

It is either subforms (a subform on each tab) or a query.

Do we have a limited fields for the query?

Khalil