Wildcards as criteria from forms

[R Greenwood]

Access 2003. I have set up a form to provide the criteria for several queries
and one of the queries needs to select specific text values from a string. If
I enter the required value with and asterisk at either end into the design
grid of the query it works just fine. However when the same value is supplied
via the form the query does not work and it would seem likely that the
process strips out the asterisks. How can I get this to work.

 

[Douglas J. Steele]

How are you referring to the control in your form? Are you using the LIKE
keyword?

 

[Robert_DubYa]

Try using this:
Like "*" & Trim([Forms]![form name]![field name])

 

[R Greenwood]

I am using [forms]![frm Front End!]![Shedule Rate] where Front End is the
form and Schedule Rate is the control.