https://bugs.documentfoundation.org/show_bug.cgi?id=103557
--- Comment #1 from [email protected] ---
At this moment you could
1. Create a table "filter" only for one row with
ID - BOOLEAN, primarykey
date_start - DATE
date_end - DATE
2. Put in the first value for ID: TRUE
3. Create a form for this table with
date_start
date_end
(there you could choose the dropdown you wish)
4. Set this form by the filter to show only the values for ID = TRUE
5. Set the cycle of the form "only this row" (don't know how it is called in
English GUI)
6. Add the query to a form beneath this one - mustn't be a subform.
7. Add a button to this form, which should refresh the query.
That's the way to get what you want.
You might get the same result with macros - but this one works without and you
could also get the content of the last input when only opening the query,
because the values of your table would be read out of "filter"
( ... WHERE "start_date" = IFNULL(SELECT "date_start" FROM "filter" WHERE "ID"
= TRUE), "start_date") AND "end_date" = ...)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
