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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Criteria

Status
Not open for further replies.
Dickx

Dickx

Technical User
Aug 24, 2001
33
US
If I call for, in the criteria line of a query a prompt, that would require an input, such as a City, is it possible for that prompt to be in the form of a combo or list box that would provide a list of choices from a drop down.
 
Sort by date Sort by votes
No.

You would have to design a form containing the combo and then relate the criteria to the form combo.
Forms!myformname!mycomboname
The user would have to choose from the combo first and then initiate the query, probably with a button on the form.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top