Hello!  I like the combo box to choose which records to see in the appointment form.  I wanted to use this same concept except using a yes/no field to toggle between active and inactive.  I put a y/n control on the form and am using it to reference the y/n state of each record.  I'm not even getting a msgbox returned to me from my code so I guess I'm not referencing it correctly.  I'm confident my record source is good because I'm using it as my recordsource for the form:

SELECT RouteT.*, RouteT.Active FROM RouteT WHERE (((RouteT.Active)=True));

Here is the code:
Private Sub ToggleActive_Click()
    If ToggleActive = True Then
        Me.Recordset = "SELECT RouteT.*, RouteT.Active FROM RouteT WHERE (((RouteT.Active)=False));"
    Else
        Me.Recordset = "SELECT RouteT.*, RouteT.Active FROM RouteT WHERE (((RouteT.Active)=True));"
    End If
End Sub