criteria based on a form

A

angie

i have a field and i enter the following criteria: like
[forms]![formname]![fieldname] , but i get no data.
if for example i enter in my form test i want the query to return data that
start with the word test (i.e. test*). how can i solve this problem?
 

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

Pull criteria from a Form 2
Access Dcount (multiple criteria) 3
Use Table field in query criteria 1
list box criteria 4
Expression for Criteria for Form with Combo Boxes 1
Using Form for Query Criteria 2
query criteria 2
Additional fields for form based parameter query/null fields 2

Top