Page 1 of 1

Dropdown list in query parameter input

PostPosted: Fri Nov 08, 2019 5:00 pm
by 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

Re: Dropdown list in query parameter input

PostPosted: Fri Nov 08, 2019 5:51 pm
by 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:https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=42845