thank you Bruce. I have the Query setup as well as the stand alone or unbound form with the listbox in it.
I find a way to get the form to execute the Query. In the controls window, I am finding where actions can trigger, but it only appears to allow me to add macros...I can't type anything in the text boxes next to the event items. I've also tried adding a push button hoping a wizard would come up to build the action...no such luck. I'd prefer not typing in all 12+ categories in the Query criterion field as more categories will be added in the future on an as-needed basis. Plus some are rather longly named. Can you or anyone assist with getting a form to execute a query? The "help" was more like a dictionary than a how-to. thank you in advance, alanon On Aug 27, 2016 6:31 PM, "Bruce Hohl" <bruceh...@gmail.com> wrote: > > What would I need to write as a criteria so that when the QUERY is run, > it > prompts the user to select from a listbox > > You must create a form to use the List Box control. If you really only > need a query you can add the choices to the query parameter name. For > example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" = > :enter_dog_cat_or_bird (see simple attached example). > > From the installed help see: Contents > Database Functionality > General > Information > Working with Queries (Query Design / Parameter queries) and > Working with Forms (Form Controls / List Box). > > > On Sat, Aug 27, 2016 at 3:14 PM, alanon <alanon....@gmail.com> wrote: > >> Hi, >> Thank you in advance for your help! >> I'm trying to build a query that would list the records in a database >> where >> the user selects from an existing list of categories. >> >> IE >> there are 12 existing categories, each with a bunch of records. >> the user wants to review just the records under the category "gas", but he >> doesn't know that exact category name so he needs a listbox to show his >> existing categories to select from. >> >> What would I need to write as a criteria so that when the query is run, it >> prompts the user to select from a listbox so he can review the records for >> that said category? >> >> Thank you. >> Alanon >> >> >> >> -- >> View this message in context: http://nabble.documentfoundati >> on.org/libreoffice-base-building-query-need-help-with- >> input-parameter-development-tp4191909.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-uns >> ubscribe/ >> 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: 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
