Event Code for Tab Control

[painterz]

Hi All,

I had a form (Address) containing a subform (People) and the main form was based on a query, qryNeighbors--everything worked.

Then I realized I actually needed a tab control to show multiple families living at the address. So each tab would represent a family and contain the subform.

My goal is to write code using SELECT DISTINCT to pull out the FamilyID(s) of each family and then feed it through qryNeighbors for the data and place it in the subform on the tab page.

I think it probably goes in the OnLoad event of Address form. Is this the best place to put it? Is there an easier way to show one family per tab without writing code? I know there isn't a recordsource for a tab control, is there something else that will work more smoothly? I feel like I'm reinventing the wheel.

Thank you for taking the time to ponder this problem.

 

[JHB]

I would use a sub-from/list-control, (placed to the left), showing Family 1, Family 2, Family .. instead of the tab-control.

 

[painterz]

That sounds interesting--what does it look like? Do you have a screen shot?

 

[JHB]

That sounds interesting--what does it look like? Do you have a screen shot?

Not exactly concerning families, but if you imagine that where the years are listed that it shows "Family 1", "Family 2", "Family .."

 

[painterz]

Sorry for the late response. I really like this idea! I would actually have a recordsource to sort the families and that will need less coding. Thank you!!!