I can't get this right but it would seem odd if it can't be done.



When you make a tab form with multiple tabs to be used as the main form 

for an application, how do you get each tab to get it's data from a 

different table or query. So far my whole tab control just works on 1 table



Please help

Thanks

Deon

Deon,



Several ways of doing it but the simplest is to create subforms

connected to the appropriate recordsets and place them on each of the

'tab sheets'.



Regards



Paul



-----Original Message-----

From: grephest@y... [mailto:grephest@y...] 

Sent: 28 January 2002 08:52

To: Access

Subject: [access] TAB FORM - MULTIPLE TABLES





I can't get this right but it would seem odd if it can't be done.



When you make a tab form with multiple tabs to be used as the main form 

for an application, how do you get each tab to get it's data from a 

different table or query. So far my whole tab control just works on 1

table



Please help

Thanks

Deon

> Several ways of doing it but the simplest is to create subforms

> connected to the appropriate recordsets and place them on each of the

> 'tab sheets'.



I've not worked with tabs yet, but if subforms are not your thing, is it 

possible simply to have an On Click event for the tab and merely change 

the form's RecordSource for each tab click?



Greg

You have to put a subform(s) into the tab page(s).



-----Original Message-----

From: grephest@y... [mailto:grephest@y...]

Sent: Monday, January 28, 2002 8:52 AM

To: Access

Subject: [access] TAB FORM - MULTIPLE TABLES





I can't get this right but it would seem odd if it can't be done.



When you make a tab form with multiple tabs to be used as the main form 

for an application, how do you get each tab to get it's data from a 

different table or query. So far my whole tab control just works on 1 table



Please help

Thanks

Deon