Make code that skips zeros

[smask]

Skips zeros!

Hi!

I've got a form that shows some data. This data can also be zero (0) and then I don't want to show it in my form.

With List7
If .RowSource = "SELECT * FROM Urnaquery WHERE [Expr1]" > 0 Then
.RowSource = "SELECT * FROM Urnaquery WHERE [Urna] Like '" & _
IIf(chkExactMatch = True, Me.kn & "';", "*" & Me.kn & "*';")
.Requery
End If
End With

This doesn't work! any suggestions?

/ Smask

 

[llkhoutx]

I don't think that

if .RowSource = "SELECT * FROM Urnaquery _
WHERE [Expr1]" > 0 then

in and of itself isn't a valid expression.

if .RowSource = "SELECT * FROM Urnaquery _
WHERE [Expr1] > 0" then

is.

Is that what you want? If your're wanting [Expr1] to calculate, it won't in the code you've written because it's contained within a string.

I not sure what you're testing. Are you?"