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,
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 -->
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,
- select tab index 0, record source of frmTaskSummary qrySummary0
- select tab index 1, record source of frmTaskSummary qrySummary1
- select tab index 2, record source of frmTaskSummary qrySummary2
- 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 -->