Wildcards as criteria from forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
How are you referring to the control in your form? Are you using the LIKE
keyword?
 
I am using [forms]![frm Front End!]![Shedule Rate] where Front End is the
form and Schedule Rate is the control.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Record contains wildcard char 2
Acknowledge an asterisk as a string 3
sql and wildcards 2
Wildcard in using a form for query criteria? 1
Criteria from Form 3
Query Parameter using multiple options 0
wildcard for date criteria to return all records 1

Back
Top