By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

Setting up a Query Report that uses a Combo Box

P: n/a
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"?

May 16 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
put a combo box on a form and then reference that combo box in your query

<em*********@gmail.comwrote in message
news:11**********************@l77g2000hsb.googlegr oups.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"?

May 16 '07 #2

P: n/a
On 16 May 2007 13:50:42 -0700, "em*********@gmail.com"
<em*********@gmail.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]
May 16 '07 #3

P: n/a
"em*********@gmail.com" <em*********@gmail.comwrote in
news:11**********************@l77g2000hsb.googlegr oups.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

May 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.