William Hindman
wdhindman at dejpolsystems.com
Sat May 10 10:38:52 CDT 2008
...this is older than the hills but its still my bread & butter tab change code: Private Sub TabCtl0_Change() Dim tbc As Control, pge As Page ' Return reference to tab control. Set tbc = Me!TabCtl0 ' Return reference to currently selected page. Set pge = tbc.Pages(tbc.Value) ' Message box showing what page has been selected ' for testing purposes only 'MsgBox "We are now on " & pge.Name If pge.Name = "Page3" Then If IsLoaded("frmCompanyEventsSub") Then DoCmd.Close acForm, "frmCompanyEventsSub", acSaveYes End If Forms!frmCompany!CompanySub.Visible = True Forms!frmCompany!CompanySub.SourceObject = "frmCompanyContactsSub William -------------------------------------------------- From: "Arthur Fuller" <fuller.artful at gmail.com> Sent: Saturday, May 10, 2008 11:19 AM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Conditional Form Footer Visibility > How does one refer to the pages of a tab control from within its tab > change > event? > Arthur > > On Sat, May 10, 2008 at 10:42 AM, Rocky Smolin at Beach Access Software < > rockysmolin at bchacc.com> wrote: > >> Arthur: >> >> I'd try using mouse move of the page to put in Me.Section(2).Visible = >> False on the page where you want the footer to disappear and >> Me.Section(2).Visible = True on the pages where you want the footer >> visible. >> >> >> Rocky Smolin >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >