Libreoffice Base Formularios Avanzados ((link)) Jun 2026

' Dynamically rewrite the SQL for the City List Box ' Note: We must use quoted strings carefully here oCityListBox.ListSource = "SELECT ""CityName"", ""ID"" FROM ""Cities"" WHERE ""RegionID"" = '" & sRegionID & "'"

I discovered the RowSource property. The solution wasn't in the GUI, but in a Basic macro triggered by the After Update event of the Region list box. libreoffice base formularios avanzados

"The cashier closed out ten tables in four minutes. The stock boy printed an order for just the right amount of chiles. And the new waiter found a customer's favorite table by searching 'ventana' in the client form." She smiled. "The only disaster is that we have nothing to complain about anymore." ' Dynamically rewrite the SQL for the City

The client complained that when they clicked "New Record," typed rapidly, and moved to the next field, the form flickered. It was the "Refresh" lag. The stock boy printed an order for just

msg_box.execute()

"I’ll use LibreOffice Base," I told them. "It's free, it's powerful, and it handles HSQLDB and Firebird out of the box."