Setting RecordSource Dyamically

[Paul H]

I'm setting the where clause for a query (the forms recordsource). On a numeric field if the user does not set a value, l want to select all records. I thought the simplest solution would be set the criteria to be Like "*", but this does not work. I am contructing this like so;

if cboFilter.value = cboFilter.defaultvalue then
Filter1 = [myFieldName] & " Like '*' "


Else
Filter1 = [myFieldName] & " = " & me.cboFilter
End if

Hope you can help. I'm under a deadline

[rpeare]

if you're setting the filter you also have to set the filter on

In the design view of your report go to the FILTER ON LOAD property and change it to YES.

[Paul H]

This aren't filters really, they are criteria in a WHERE statement of a query. The problem is Numeric Fields don't like Like "*". as a fix I just substituted ">0". I just was looking for a numeric substitute to "*"

[rpeare]

is not null would search a numeric field that had any value other than null

[Paul H]

rpeare,

I forgot to thank you. This work just fine and also helped me locate records where this value WAS null.

Paul