Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query offering choices

Status
Not open for further replies.
dcranford

dcranford

MIS
May 18, 2000
131
US
Is it possible that when a query is run, it displays a "dropdown" box of some sort with choices to choose from? I don't want the query to "call a form" with an unbound field. I want to be able to embed choices inside of the query; maybe in the Criteria row, so that the user can select from that list and have the chosen selection be used as the true criteria of the query. For example, I want to view my users in Building B. I want to run the query and see a dropdown box listing
Building A
Building B
Building C

Once I choose Building B, the query kicks in and displays the results. Deon Cranford
dc2@scotlandhealth.org

 
Sort by date Sort by votes
it is not possible to do such a thing without the use of a form.
Erez.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
476
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
390
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
360
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
274
JimStrand
JimStrand
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
465
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top