Filter on/off toggle

[Dave White]

Hello everyone,

When I open this Form it displays all the records

I then use a command button to apply a filter to these records.

I would like to change the command buttom to a toggle switch that
would:
1. apply the filter when it is in the up position
2. remove the filter and show ALL the records when it is in the down
position.

I'm not having much luck. Any suggestions would be appreciated.

Dave

[Wayne Morgan]

In the Click event of the button and the Current event of the form you need
to check the value of the button (true or false, i.e. up or down) then use
and If..Then..Else statement to do what you want depending on the value of
the button. The button is True when pressed and False when up.

--
Wayne Morgan
MS Access MVP
"Dave White" <dj*****@snet.n et> wrote in message
news:mt******** *************** *********@4ax.c om...

Hello everyone,

When I open this Form it displays all the records

I then use a command button to apply a filter to these records.

I would like to change the command buttom to a toggle switch that
would:
1. apply the filter when it is in the up position
2. remove the filter and show ALL the records when it is in the down
position.

I'm not having much luck. Any suggestions would be appreciated.

Dave

[Salad]

Dave White wrote:

Hello everyone,

When I open this Form it displays all the records

I then use a command button to apply a filter to these records.

I would like to change the command buttom to a toggle switch that
would:
1. apply the filter when it is in the up position
2. remove the filter and show ALL the records when it is in the down
position.

I'm not having much luck. Any suggestions would be appreciated.

Dave

'expanding on what Wayne stated
Private Sub Toggle0_Click()
If Me.Toggle0 then
Me.Filter = "EmpID = 1"
else
Me.Filter = ""
Endif
Me.FilterOn = Me.Toggle0
End Sub