Like op (1 Viewer)

[mission2java_78]

If I type in Like '*C.31000.*' then it works fine...
but I want it so that it will accept anything in the text box rather than me hardcoding a number...
Jon

 

[Jack Cowley]

I assume that this is criteria for a parameter query... In the criteria line use code like this:

Like "*" & [Forms]![FormName]![ControlName] & "*"

hth,
Jack