Is there any easy way to use the equivalent of a combo box to filter a query ie when you run the query , have combo box appear with a list of allowable paramaters (eg States or countries) and have the ability to select all of them, just one or a number of them to feed the query
TIA
Steve
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Combo Box as parameters for a query (2003 All Updates)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Combo Box as parameters for a query (2003 All Updates)
- This topic has 10 replies, 3 voices, and was last updated 18 years ago.
AuthorTopicWSstevecox4444
AskWoody LoungerMay 27, 2007 at 4:05 am #442705Viewing 1 reply threadAuthorReplies-
WSHansV
AskWoody LoungerMay 27, 2007 at 6:25 am #1066263Use a combo box on a form, and set the criteria to something like
[Forms]![NameOfForm]![NameOfComboBox]
The form should be open before the query is used. The form won’t be opened automatically if the query is run from the database window, but since end users should never run something from the database window, that shouldn’t be a problem. -
WSstevecox4444
AskWoody Lounger -
WSHansV
AskWoody Lounger -
WSstevecox4444
AskWoody LoungerMay 28, 2007 at 10:10 pm #1066417Following on from help by Hans and John, I attach a cut down version of the database.
Two major tables: STKB which holds data relating to Stock and DAVEID which holds the list of GROUPS.
The ChooseGroupsForm is designed to allow you to choose one, several or All Groups. This process is working fine (after much confusion on my part !!). However I want to apply the results of this query to the query qryProductProfitabilitySearch and have no idea how to do this.
Any help appreciated
TIA
Steve -
WSHansV
AskWoody LoungerMay 28, 2007 at 10:27 pm #1066419You have an organizational (or design) problem that you’ll have to solve before continuing. The IDCODEs in the DAVEID table do not correspond to the IDCODEs in the STKB table. For example, DAVEID contains the IDCODE “WINE”, containing descriptions such as “WINES”, “WINES RED”, “WINES WHITE” etc. However, the records in STKB that are about wines contain IDCODEs such as REDS, WHIT and SWIN. Because of this inconsistency, you cannot join the tables on the IDCODE field. You will have to tackle this first. You’ll have to decide for yourself in which table you’re going to change the codes to match those in the other one. And perhaps you should use the CODENO field from DAVEID, but I don’t see an equivalent field in STKB at first sight.
-
WSstevecox4444
AskWoody Lounger -
WSHansV
AskWoody Lounger -
WSstevecox4444
AskWoody LoungerMay 29, 2007 at 10:50 pm #1066566Hans
Thank you – the query is now working well. I had to change the source from the Table STKB to a query as there are calculated fields required in the report and I noticed that it would only read the first 4 letters of the query name (presumably because the original table source was 4 letters long). I just changed the name of the query to be 4 letters long
However, because of my inexperience, I have had to make production of the associated report a 2 step process (2 buttons on the form)
Button 1 calls up the query after selections are made
Button 2 opens the report based on this query
It works but its not pretty. Is there anyway to open the report in preview mode as soon as the groups are selected and the “run query” button clicked
Steve -
WSHansV
AskWoody LoungerMay 29, 2007 at 11:16 pm #1066567You don’t have to alter a query before opening the report. you can pass the where-condition to the report. See the attached version. The report is nothing special, just a slightly modified autoreport; it is only meant as an illustration that you can use one query and one report to display different selections.
-
-
-
-
WSjohnhutchison
AskWoody LoungerViewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
CD/DVD drive is no longer recognized
by
WSCape Sand
1 hour, 31 minutes ago -
Windows 11 24H2 Default Apps stuck on Edge and Adobe Photoshop
by
MikeBravo
4 hours, 20 minutes ago -
North Face and Cartier customer data stolen in cyber attacks
by
Alex5723
2 hours, 26 minutes ago -
What is wrong with simple approach?
by
WSSpoke36
2 hours, 18 minutes ago -
Microsoft-Backed Builder.ai Set for Bankruptcy After Cash Seized
by
Alex5723
13 hours, 50 minutes ago -
Location, location, location
by
Susan Bradley
52 minutes ago -
Cannot get a task to run a restore point
by
CWBillow
15 hours, 16 minutes ago -
Frustrating search behavior with Outlook
by
MrJimPhelps
6 hours ago -
June 2025 Office non-Security Updates
by
PKCano
1 day, 2 hours ago -
Secure Boot Update Fails after KB5058405 Installed
by
SteveIT
8 hours, 5 minutes ago -
Firefox Red Panda Fun Stuff
by
Lars220
1 day, 1 hour ago -
How start headers and page numbers on page 3?
by
Davidhs
1 day, 12 hours ago -
Attack on LexisNexis Risk Solutions exposes data on 300k +
by
Nibbled To Death By Ducks
15 hours, 4 minutes ago -
Windows 11 Insider Preview build 26200.5622 released to DEV
by
joep517
1 day, 21 hours ago -
Windows 11 Insider Preview build 26120.4230 (24H2) released to BETA
by
joep517
1 day, 21 hours ago -
MS Excel 2019 Now Prompts to Back Up With OneDrive
by
lmacri
1 day, 10 hours ago -
Firefox 139
by
Charlie
1 day, 3 hours ago -
Who knows what?
by
Will Fastie
5 hours, 44 minutes ago -
My top ten underappreciated features in Office
by
Peter Deegan
1 day, 21 hours ago -
WAU Manager — It’s your computer, you are in charge!
by
Deanna McElveen
40 minutes ago -
Misbehaving devices
by
Susan Bradley
17 hours, 31 minutes ago -
.NET 8.0 Desktop Runtime (v8.0.16) – Windows x86 Installer
by
WSmeyerbos
3 days, 3 hours ago -
Neowin poll : What do you plan to do on Windows 10 EOS
by
Alex5723
2 hours, 36 minutes ago -
May 31, 2025—KB5062170 (OS Builds 22621.5415 and 22631.5415 Out-of-band
by
Alex5723
3 days, 2 hours ago -
Discover the Best AI Tools for Everything
by
Alex5723
2 days, 1 hour ago -
Edge Seems To Be Gaining Weight
by
bbearren
2 days, 16 hours ago -
Rufus is available from the MSFT Store
by
PL1
3 days ago -
Microsoft : Ending USB-C® Port Confusion
by
Alex5723
4 days, 3 hours ago -
KB5061768 update for Intel vPro processor
by
drmark
2 days, 3 hours ago -
Outlook 365 classic has exhausted all shared resources
by
drmark
2 days, 2 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.