Dropdown list in query parameter input

[MHCom]

Hi, apologies if this has been asked a lot already. I have a query with a parameter input (I've put :Name in the Criterion box that I want to filter results by) and a parameter input box comes up as expected when I run the query.

What I would really like to happen is that rather than just a blank free text box coming up, a dropdown list with all the unique values in the field comes up, so the user can select a valid entry to filter by. Is this possible?

Thanks

[F3K Total]

Yes,
it's possible to do in a form, using i.e. a one row filter table, see lot's of info here:viewtopic.php?f=100&t=42845

[Kirjava]

That's nice, but how do I put a drop down box on a QUERY?

[Villeroy]

Forms are for user input.
Reports are for printable output.
Queries are not part of the user interface. They are more like development tools for data processing.

[Kirjava]

How do I make the Value field in the "Parameter Input" box on a query be drop down instead?

[Nick N,]

Hi,

Take a look at below example.

Regards

Nick

[Kirjava]

That is on the FORM, I am asking about the QUERY.

[Nick N,]

All you have to do is to edit the form, then the list box and select control box as follows...
In any case make yourself more clear, OK?

[Kirjava]

HOW TO MAKE PARAMETER INPUT FOR QUERY A DROPDOWN BOX

[Nick N,]

Dear Mr. Kirjava,

Capitals are in netiquette deprecated, await therefore your excuses.

Regards

Nick

[RoryOF]

It is worth noting that in OpenOffice /Tools /Macros /Organise Macros /OpenOffice Basic, under OpenOffice Macros : Tools there is a complete set of macros to handle Listboxes.

They may be under a similar position in Libreoffice (mutatis mutandis).

[Nick N,]

Halleluja Rory,

Have a nice Holiday!

Nick