Tabbed Form Question

[canjfn]

If I have a tabbed from of say 3 tabs, can I use each tab to populate 3 different tables or can each tab only populate one table, hope this is clear.

I have 3 tables

a) General
b) Process Design
c) Mechanical design

By putting the tabbed form on a plain master form, I have to select one table for the record source for the master form, thus it would appear is the only table I can populate.

Thanks in advance

 

[boblarson]

Create a form for each type, then on each tab add that form in as a subform and if they truly are autonomous, don't set a link in the subform wizard.

 

[canjfn]

Thanks, I feel a right idiot now, was racking my brains for a simple solution

 

[boblarson]

Hey, don't feel bad. You can't know everything. It may sound simple, but if you don't know how to do it, it doesn't really matter now does it? That's what all of us are here for - to help each other continually learn and solve the problems that we don't know how to fix ourselves.