Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Bruce,

> On form Form_Filter, is it possible to define the List Box using 
> General - List Entries and Data - ValuelList

No problem to define it separately. But I would only use this kind of
entries if I would knew all entries, which ever should be chosen by
the listbox. So, for example, a listbox for "Mrs.", "Mr." or something
like this. All others I would fill with entries of a table of the
database.

> (without using the separate table Filter and query Query_Filter)?
What you write inside the brackets has nothing to do with the
value-list of the listbox. It is one possibility to filter a table by
a listbox without using any macro. You could get nearly the same
result with a construction of mainform and subform. Then you could do
it without the table "Filter", but also without a listbox. You could
only navigate through the mainform with the distincted values of
"Category" and the subform will show the rows of this "Category".

> The Base Handbook has brief comments on the List Entries & 
> ValueList but only defining those items does not produce a working 
> List Box.

The entries you are defining must match with the entries the field for
the values would accept. You could create a listbox without any
connection to data of any table - but you can't use this for a filter
without also using macros.

Regards

Robert
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBAgAGBQJXwyccAAoJELDKYwaoS9AIk8oP/3zLBk6VFpEBV71PCcgQPWbH
iF9I4sMa2xtn2Eb6KvPmTcq8zG5AjowObbamAscGX79Tsk9Oue23lmRSbX3mXcRR
M1SjsWDHKbFKGAbJQM1XPEbBarUNRcT8Y2BWp7BhRLmcFpL0uB/Xw/xaLALfFo3y
xb+Siw2TetMOu6eBXV3HCSt5Bi5fh/iDJ0YXlELdOoteGgrmaPpFjG5p86Ztybjn
7RlRT4tZZNC2DIfczFT2iXu0K8pIfFQVqz7p2e3Q/On12EvAViP4AbP1hg4/kLMI
hKsheA1zvm7N4/JgH33wbAxPB7Fh1cTVkciEIVGyIzusCb9wgJpjdW1fms36NuNa
OxIX9GCTGG7S7SdNW+9H8eCpRyCX8GkWDQCDlHe8jqqAid41XiiZcG0TxbARmRRN
mV+4u5OyNfJewGyxh1noFjRB1ZwIKz8aWyt70b3nmsGAfWkcZFMQa4m65wqvyiS3
F/ThPXIGj1TdbfbnC+kIySVBGzE452b/lzElNclXagg1KtmTzkXAVH5/WMEACfHJ
ov8NCwZFYm667JHkQkAkQUAejoEs7HZgXPOVDGNLu09wTiUNQClWkRZyxW1rvvMz
mEOVi1ia/vRQgMJcozecqqj44a8FBLDdx063s55AOJclKmeKl2u3kQb3t6/nZlen
gjZDA1WYnmzOnDkFG1fG
=tpYZ
-----END PGP SIGNATURE-----

-- 
To unsubscribe e-mail to: users+unsubscribe@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