Robert, Sorry not to have been back sooner - I got distracted by some more important work than managing my wine.
I've worked out now how your filter_without_macros works now, and am in the process of adding the procedures into my database. I've also found your Base handbook on the LO website. It's really useful, and a pity it wasn't there when I started working with Base (some years ago now). So double thanks. Best regards, Peter mailto:l...@ptoye.com www.ptoye.com ------------------------- Friday, January 27, 2017, 6:05:01 PM, you wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 27.01.2017 um 16:21 schrieb ptoye: > Hi Robert, > > I've had a look at some of your forms now, especially > filter_without_macros and I'm a bit puzzled. I see that the table > in the Display part of the form is populated by the "filterquery" > query, which references "filter". The table "filter" has one entry > - the selection(s) I made in the listbox. But I can't see how the > listbox selections get put into the "filter" table. Can you please > help me there? Could be this is a special behavior of Base-forms. There are two forms beneath each other. One form for "filter" and one for "display". I change values in "filter". I move to a button in "display". The content of "filter" will be saved when I push the button in "display" before the action of the button will happen. So there is needed only one button, which should refresh the form "display". The query for this form will be filtered by the entries in the table "filter". > I also can't understand why there are two columns in the > "listbox_n_simple", but that's of less importance. Most listboxes will show some text-content, but are linked to a table by an Integer-primarykey. So queries for listboxes look like SELECT "name", "ID" form "table_names" "name" will be shown. "ID" will be saved in the column of the form. You must have a look in the properties > data of the listbox. The "bounded field" will be '1' by default - and '1' is (a little be confusing, because it begins with '0') the second field. If the same content should be shown as it will be saved you could set this to '0' - so there must be only asked for one field. You could also set this to '-1'. This will save the numer of the row. I have never used this, but it works ... Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd 0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8 dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT /BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3 93NMpdUU7TC9gmjU8JVp =u2Z4 -----END PGP SIGNATURE----- -- To unsubscribe e-mail to: [hidden email] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206382.html To unsubscribe from Can I reload a form based on a parameter query?, click here. NAML ----- Peter -- View this message in context: http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4207833.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted