Passing all (" * ") to query via Code

[claudebo]

Hi

I have a number of queries that are passed criteria via code

Query view:

|Field |CusLastName | etc.
|Table | CusTable |
|Criteria |Queryprop("Pass&quot|

Example Code:
"Function Queryprop(Prop) As String
Queryprop = Currentprop
End Function"

This works fine when the values are defined : "Smith"

The problem is when I want the query to pass all values
"*"
It does not recognize the *
How can I get it to show all CusLastNames as a passed value in function Queryprop.

Thanks
Claude

 

[Junior1544]

the reason is that in the query you have an = not a like...

look at using the term like

The way I deal with this is that I have an if then, and build my own sql statement... then open a recordset and do what I need there...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.