Created attachment 193397 [details] Database document with 2 forms for testing the form based filter There is a property "Filter proposal" in the properties dialog of a data form's text box. With this property is set, the text box turns into a listbox when the form is in form based filter mode. Open the members form in the attached database. Start the form based filter. Below the "Member Name" label there is a listbox which should show the distinct names to be selected as filter criterion, but the list is empty. Work-around: Open the other form with the combo box where the same procedure does work, because I replaced the text box with a combo box.
Thank you for reporting the bug. I can confirm that the bug is present in Base. Verified "filter proposal" doesn't produce a list using the data from the sample document, whereas the workaround using a combo box does. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e939685f9c6918830bd3097062790bfccbce937e CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to Andreas Säger from comment #0) > Created attachment 193397 [details] > Database document with 2 forms for testing the form based filter > > There is a property "Filter proposal" in the properties dialog of a data > form's text box. With this property is set, the text box turns into a > listbox when the form is in form based filter mode. > Correction: It's a combo box, not a listbox. A combo box allows for pattern matching. The name of the UNO property is "UseFilterValueProposal". It is undocumented, though. At least, I can't find it in file:///opt/libreoffice24.2/sdk/docs/idl/ref/classes.html
> Work-around: Open the other form with the combo box where the same procedure > does work, because I replaced the text box with a combo box. Testing with your example, i think that the problem of your workaround is that: * I you choose a value an then apply the filter, the field with the value selected change to the new value selected. * If you apply the filter and the select a value, the filter don't refresh
(In reply to jcsanz from comment #3) > Testing with your example, i think that the problem of your workaround is > that: > * I you choose a value an then apply the filter, the field with the value > selected change to the new value selected. > * If you apply the filter and the select a value, the filter don't refresh The form based filter with a combo box behaves as expected. No table value is modified. Filters do not refresh automatically.