Switchboard Change Event to Change Record Source

[pdevito3]

Hey everyone,

So I have a form with a navigation control (a.k.a. Switchboard). One of the tabs on this tab navigation has a form with another switchboard form on it

I want each of these nested tabs to have the same form (frmTaskSummary) as their targets, but I want the record source of that form to change based on the selected tab. For example,

1. select tab index 0, record source of frmTaskSummary qrySummary0
2. select tab index 1, record source of frmTaskSummary qrySummary1
3. select tab index 2, record source of frmTaskSummary qrySummary2
4. etc.

Is this possible? I can handle writing the VBA, but I am not familiar with the specific syntax here... I know that if I used a tab navigation I can use the "On Change" event, but I would rather not rebuild at this point. Regardless, thanks for your time.
<!-- / message -->

<!-- controls -->​

 

[pdevito3]

bump...