me.filter

[tubar]

if the user selects rear projection from the combobox on my form;then, the form filters the "screen" column displaying all screens except the one with the id of 1...what am i doing wrong with my code?

Private Sub Combo9_AfterUpdate()
If Me.Combo9 = "REAR PROJECT" Then
Me.Filter = "SCREEN =>1"
Me.FilterOn = True
Else
If Me.Combo9 = "FRONT PROJECT" Then
Me.FilterOn = False

Else
End If
End If


End Sub

 

[pbaldy]

Try reversing the operators:

>=