Setting up a Query Report that uses a Combo Box

[emily.a.day]

I have a book database, and I have set up a query to search by
subject. As it is now, the searcher has to know the subject and type
it into the query. I wonder if there is a way to have a combo box
where the searcher can select the subject before running the query,
rather than consulting the separate subject list and typing the
subject in manually.

I have tried sticking the combo box in the report, but can't figure
that out. I think I need to change the query's criteria, and I know
how to link it to a combo box, but since I don't know where to put the
combo box, I don't know what combo box to link to. Can I put the
combo box in the report? How do I do that?

So my specific question is, how can I change the "type it in yourself
and hope it matches the subject table" method of querying to "select
from the drop-down menu"?

[Scott]

put a combo box on a form and then reference that combo box in your query

<em*********@gm ail.comwrote in message
news:11******** **************@ l77g2000hsb.goo glegroups.com.. .

>I have a book database, and I have set up a query to search by
subject. As it is now, the searcher has to know the subject and type
it into the query. I wonder if there is a way to have a combo box
where the searcher can select the subject before running the query,
rather than consulting the separate subject list and typing the
subject in manually.

I have tried sticking the combo box in the report, but can't figure
that out. I think I need to change the query's criteria, and I know
how to link it to a combo box, but since I don't know where to put the
combo box, I don't know what combo box to link to. Can I put the
combo box in the report? How do I do that?

So my specific question is, how can I change the "type it in yourself
and hope it matches the subject table" method of querying to "select
from the drop-down menu"?

[John Thomas Smith]

On 16 May 2007 13:50:42 -0700, "em*********@gm ail.com"
<em*********@gm ail.comwrote:

>combo box where the searcher can select the subject

I have a database with a Purchase Order Number PONum

On a PrintMain form, I have a POLook field for the PONum

In the query to product a report, I have in the PONum field

[forms]![PrintMain]![POLook]

[Bob Quintal]

"em*********@gm ail.com" <em*********@gm ail.comwrote in
news:11******** **************@ l77g2000hsb.goo glegroups.com:

I have a book database, and I have set up a query to search by
subject. As it is now, the searcher has to know the subject
and type it into the query. I wonder if there is a way to
have a combo box where the searcher can select the subject
before running the query, rather than consulting the separate
subject list and typing the subject in manually.

I have tried sticking the combo box in the report, but can't
figure that out. I think I need to change the query's
criteria, and I know how to link it to a combo box, but since
I don't know where to put the combo box, I don't know what
combo box to link to. Can I put the combo box in the report?
How do I do that?

So my specific question is, how can I change the "type it in
yourself and hope it matches the subject table" method of
querying to "select from the drop-down menu"?

Query? queries are for supplying data to forms, not for user
display. Make two forms, one to show your combobox, and a button
to execute the second form, to which you pass the results of the
first form as a filter. You can even make the second form look
like a query, but with all the added features offered by a form,
such as locking your data.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com