Use Command Button & Code to Hide and Unhide Form Footer

[ANTHROPOIDLUVA]

Is there a code that would allow form footer section and its contents to remain hidden until a command button is clicked when viewing form on computer screen? Please help.

[theosgood]

I'm still learning Access but this sounds similar to how I hide/show two different tabs in a tabbed form.

First I set the tab property, AdPanelTabZ.Visible = False
Then I have this code on a button.

Private Sub Zone_RegionSelect_Click()
Me.AdPanelTabZ.Visible = True
Me.AdPanelTabZ.SetFocus
Me.AdPanelTabR.Visible = False
End Sub

This makes AdPanelTabZ visible and hides AdPanelTabR. I have another button to reverse the visible properties. I'm not sure if footers can be handled the same way but hopefully this points you in the right direction.

[pbaldy]

Me.Section(acFooter).Visible = True