Drop-down list in parameter query

[limperger]

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

[nico5038]

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)

[limperger]

Nico:

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

Best regards

[nico5038]

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)

[missinglinq]

I think this tutorial addresses Nico's suggestion.

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

Linq ;0)>

[limperger]

Nico, linq:

Thank you very much for your help.

Best regards!

[nico5038]

No thanks needed, glad to help you and success with your application!

Good link linq :-)

Nic;o)