Is there a way to get the navigation buttons only to be shown when a specific
criteria it met?
Sometimes I want them to be shown and other time not.
How can I accomplish this?
Brendan Reynolds - 18 Oct 2005 19:40 GMT
The details will depend on what your criteria are, but by way of example ...
Private Sub Form_Current()
If Me.TestID Mod 2 Then
Me.NavigationButtons = True
Else
Me.NavigationButtons = False
End If
End Sub

Signature
Brendan Reynolds
> Is there a way to get the navigation buttons only to be shown when a
> specific
> criteria it met?
> Sometimes I want them to be shown and other time not.
> How can I accomplish this?
Klatuu - 18 Oct 2005 19:49 GMT
Yes, Me.NavigationButtons = True to turn them on
Me.NavigationButtons = False to turn them off
> Is there a way to get the navigation buttons only to be shown when a specific
> criteria it met?
> Sometimes I want them to be shown and other time not.
> How can I accomplish this?
BruceM - 18 Oct 2005 19:55 GMT
If you are referring to the built-in navigation buttons, in the form's
Current event:
If 'condition is met' Then
Me.NavigationButtons = False
Else
Me.NavigationButtons = True
End If
Same idea applies with custom navigation buttons (or any controls) that you
place on the form, except that Me.NavigationButtons = False is replaced with
Me.YourControlName.Visible = False
> Is there a way to get the navigation buttons only to be shown when a
> specific
> criteria it met?
> Sometimes I want them to be shown and other time not.
> How can I accomplish this?
Russ - 18 Oct 2005 23:36 GMT
Wow, thanks for all the great advise!
>Is there a way to get the navigation buttons only to be shown when a specific
>criteria it met?
>Sometimes I want them to be shown and other time not.
>How can I accomplish this?