Optional filtering (was More questions..)

[pbaldy]

FieldName = ValueToFilterOn

[Daryl2106]

Hi,

I still can't seem to get this to work. I don't know enough about code. I see the logic in the code but can't nail down the syntax. Currently I have:

Private Sub Check2107_AfterUpdate()

If Me.Check2107 = True Then
Me.FilterOn = False
Else
Me.Active = "yes"
Me.FilterOn = True
End If

The filter is based on a field called "Active" from which I enter "yes" or "no" through a combobox. By checking on the Checkbox (Check2107) I would like to have the form return only those students who are active (yes). By unchecking the box, The form would return all students.

Sorry for the lack of understanding I have with Access code.

Thanks and take care,

Daryl

[pbaldy]

Can you post the db here?