On form Form_Filter, is it possible to define the List Box using General - List Entries and Data - ValuelList (without using the separate table Filter and query Query_Filter)? The Base Handbook has brief comments on the List Entries & ValueList but only defining those items does not produce a working List Box.
On Sun, Aug 28, 2016 at 3:23 AM, Robert Großkopf <[email protected] > wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi Alanon, > > could be you are looking for something like this: > > http://robert.familiegrosskopf.de/download/Filter_Database.odb > > One table "Table" with the content you will list, one other table > called "Filter" with only one row. A query lists the content of > "Table" dependent of the content of "Filter". > > In the form there are two separate forms - one for "Filter", one for > the query. "Filter" will read out the value you have choosen from a > listbox. The button refreshes the other form for the query. There are > no macros needed. > > Regards > > Robert > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2 > > iQIcBAEBAgAGBQJXwpGJAAoJELDKYwaoS9AIIKcP/RpIgCBKZ6jtbSx8EudE9A4i > SslUhyoPzIgAOSn3daOdOLq/jBTVEOo9hF24lwiu31tyuOU2/vTYvYsXe/0hpfUp > ieJcr+jVMuVTEPIr7OtskgCkASlMDBnxe3vvzoorYSEr47xW+eczcfxINRH1r9FF > PtKhI6RRcVYDzj3meUjBPHnVrE9Wh8/7RX9+GJPVcU/GtQE3Yps77FsOhwE/iQah > q4q2wCjzYWgVTV7ls7YX1Em+dsXLuHsJtyqDaGnJr5U0hb10bLSL0D2ge8ujvMiQ > ypizv/gaKD9D7SUkfHkrqyMkmx5PPbTX+BVX0P1AjHNCAj1P99T3Nt0bRYFbffVq > 0x1a1Bt+68BZWI6sfKM6mr8fy3ZYSCdQ0uJhKklTke4ETR+2zXnLsNXUzWYJavrh > bqED7tlXvh6e0KGRARBLHXxbwN2JJx2LuODs3n0wZtqsSJu5aWdNCPnvPV7QGaRQ > dl585Kx3k73mn5iyWSnC8NSPsz7qZ6ypA8QJdPi6wy6pdfQ1tTopawqX0d+RTFBk > DGN+Fo+zVifGGPYDcNWw0SxszGNi1JiuJL4ef2GwAmF6ctmFVhR6znE6UPF92uSY > K81zrlgmqNRfVlpW1TpVPvE8gnCqakmNNVZGEZwI+S5umfMiOGjynmoWZDGgYHUk > xxmRPkrgAPQTN/pr26w2 > =MDTk > -----END PGP SIGNATURE----- > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- To unsubscribe e-mail to: [email protected] 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
