var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Changing a (sub sub) form's record source via tab control
So I have a form with a navigation control. One of the tabs within the tab navigation has another tabbed navigation form
I want each of these tabs to have the same form (frmTaskSummary) as their targets, but I want the record source of that form to change based on the tab. For example,
select tab index 0, record source qrySummary0 select tab index 1, record source qrySummary1 select tab index 2, record source qrySummary2 etc.
Is this possible? Thanks
Private Sub TabCtl1_Change()
Select Case TabCtl1.Value
ctl.RowSource = "qrySummary0"
ctl.RowSource = "qrySummary1"
ctl.RowSource = "qrySummary2"
Thanks for the response.
While it looks nice, I don't see an option either on my navigation control bar or on any individual tab or on the form itself for an "On Change" Event.
When I try to create this by hand in the VBAE, Access literally crashes
I'm assuming I'm making a simple mistake here, but I'm not quite getting it.
Also, assuming this works out, what does the "ct1" reference in your code. Is that the navigation subform, the tab itself, something else?
I just played around and saw what you are talking about. When I added a "Tab Control" I see an "On Change" event,
however, I am using a "Navigation Control" not a "Tab Control." the Navigation control doesn't seem to have this "On Change" feature.
Is there an alternative method for the navigation control?
Oh, sorry. I misread. Never found the need to make a navigaion control.
They're pretty sweet! Really cuts down on your form count... Regardless, thanks for the input.