Tab control form data source

Question

I have two tables, "Members" and "Committees". When I create a tab control form, it seems that Access 2010 insists that the record source be the same for both pages. How do you get each page to accept the data source from each individual table?

Thanks,

Bob Lee

Answer 1

I understand how to do this now. Thank you very much for your help.

Bob

Answer 2

You'll find an example of what Hans has described as FormsDemo.zip in my public databases folder at:

https://skydrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

In this little demo, in the form using  a tab control, the first page of the tab control has controls bound to column in the parent form's recordset, the second and third pages have subforms bound to two related tables.

Answer 3

A tab page does not have a record source; the form as a whole has a record source.

You could create a main form based on Members and another form based on Committees, and place one as a subform on the other (in a tab page)