Dropdown list in query parameter input

Creating tables and queries

Dropdown list in query parameter input

Postby MHCom » Fri Nov 08, 2019 5:00 pm

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?

OpenOffice 4.1.5 on Windows 7 Professional
Posts: 16
Joined: Fri Nov 08, 2019 4:55 pm

Re: Dropdown list in query parameter input

Postby F3K Total » Fri Nov 08, 2019 5:51 pm

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
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Posts: 969
Joined: Fri Dec 16, 2011 8:20 pm

Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 4 guests