hide or show bottom

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I defined, on a form properties, navigation bottoms as do not show.
So, by default they are not visible.

I would like them to be visible only when the form is filter.
Is it possible to do this?
 
You will need to filter only from code on your own buttons and disable
(replace) the default menu options. Then the code is easy:

Me.NavigationButtons = True

or if you want to toggle the navigation buttons from a command button click
event:

Me.NavigationButtons = Not Me.NavigationButtons
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Thank you for your reply Arvin.
I need navigation buttons only when a form is filtered.
Your suggestion makes it visible always.
So, I was thinking of something like… if form is filtered, then show, else
hide.

I don’t know if it is possible.


"Arvin Meyer [MVP]" escreveu:
 
Sorry, I thought you were turning the navigation button off by default, then
turning them on when the form is filtered. My code does that. If the reverse
is true and you want to turn the navigation buttons off when you turn the
filter off, then leave them turned on and change the code to:

Me.NavigationButtons = False

The actual line of code that I think you need is:

If Me.FilterOn = True Then Me.NavigationButtons = True

but you'll need to put that into code which calls the filter. As far as I
know, you can check for the filter when the form opens, but there is no
event generated by buttons on the menu or the menu and the form doesn't have
a state checking mode, so you need to run the code from a command button
which calls the filter, and disable the menu buttons. You also should turn
the navigation buttons off by default, or you'll need to change the above
code to:

If Me.FilterOn = False Then Me.NavigationButtons = False
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top