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!

Parameter Query Text Box

Status
Not open for further replies.
voltarei

voltarei

Technical User
Oct 25, 2006
40
GB
Hi All,
Is there a way that I can change the text box on my parameter query to a combo box, so rather than type in a parameter, the user can select one from the drop down list?

Many thanks
Phil
 
Sort by date Sort by votes
I guess the easiest way would be to put the combo box on a form and then when users make a choice the query is run with the criteria:

YourField = Forms!YourForm!YourCombo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
276
TrekBiker
TrekBiker
monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
203
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
185
visitnag
visitnag
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
110
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
203
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top