Passing logic operators to query

[Michael Barkemeyer]

I am attempting to pass logic operators via TempVars to query to filter a list box. What is the proper syntax as "<>5" does not seem to pass to the query properly? Sample DB attached.


Private Sub Frame0_AfterUpdate()
Select Case Frame0.Value
Case 1
TempVars.Add "tmpSelected", "<>5"
Case 2
TempVars.Add "tmpSelected", "5"
End Select
List9.Requery
End Sub