How do I use a form to run a query? How do I bind the query to it

A

Arlene

I want to run a query and also a report (based on the query) using the
criteria I select from a combo box on a form.
 
K

KARL DEWEY

Criteria --
[Forms]![YourFormName]![ComboName]

Or using wildcards --
Like [Forms]![YourFormName]![ComboName] & "*"
Like "*" & [Forms]![YourFormName]![ComboName] & "*"
Like "*" & [Forms]![YourFormName]![ComboName]
 
A

Arlene

Thansk, that worked.

KARL DEWEY said:
Criteria --
[Forms]![YourFormName]![ComboName]

Or using wildcards --
Like [Forms]![YourFormName]![ComboName] & "*"
Like "*" & [Forms]![YourFormName]![ComboName] & "*"
Like "*" & [Forms]![YourFormName]![ComboName]

--
Build a little, test a little.


Arlene said:
I want to run a query and also a report (based on the query) using the
criteria I select from a combo box on a form.
Click to expand...
Click to expand...
 

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

combo box selection will not populate query correctly 1
bound column and queries 3
Form that Runs a Query. 5
passing to criteria to a query 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Combo Box Selection To Run Report Problem 2
Parameter Value error in a Subform 0
Specifying conditional Criteria in a Query or Report 6

Top