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

Drop-down list in parameter query

P: 66
Hello everyone!

This is by no means urgent nor important, but just in case anyone has encountered this problem...
Is it possible, in a parameter query (with its default Msgbox prompting to enter the parameter data), to change the "field" of the default Msgbox (in which you type the parameter data) into a drop-down list of options?

Thank you very much in advance

Best regards
May 5 '08 #1
Share this Question
Share on Google+
6 Replies


nico5038
Expert 2.5K+
P: 3,072
Sorry, this won't be possible.

My approach would be to create a form with a combo box and pass the selected value to the query.

Nic;o)
May 5 '08 #2

P: 66
Nico:

Thank you very much for your help. I suspected this would not be possible...

Best regards
May 5 '08 #3

nico5038
Expert 2.5K+
P: 3,072
Nico:

Thank you very much for your help. I suspected this would not be possible...

Best regards
It's "by design", so only creating your own form can "solve" this.
In my own databases I often use a "SELECT Distinct fieldname FROM tblX" to fill a combo box with the existing values and allow the users to chose one for reporting.

Nic;o)
May 5 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
I think this tutorial addresses Nico's suggestion.

http://www.fontstuff.com/access/acctut08.htm

Linq ;0)>
May 5 '08 #5

P: 66
Nico, linq:

Thank you very much for your help.

Best regards!
May 5 '08 #6

nico5038
Expert 2.5K+
P: 3,072
No thanks needed, glad to help you and success with your application!

Good link linq :-)

Nic;o)
May 5 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.