display form w/o footer visible

[mark kubicki]

<this ought to be easy; but w/ inexperience comes stupidity... LOL!>

what is the code to display a form, with its footer not visible?
(i've added some user entry fields in the footer that under some
circumstances, i do not want accessible)

in advance, thanx,
mark

 

[Ken Snell \(MVP\)]

You'd need to pass a "value" to the form via the OpenArgs argument of the
DoCmd.OpenForm method, then have the form read that value and make the
footer invisible if it's the right value. For example:

DoCmd.OpenForm "FormName", OpenArgs:="NoFooter"

Then, in the FormName's Load event:

Private Sub Form_Load()
Me.FormFooter.Visible = (Me.OpenArgs & "" <> "NoFooter")
End Sub