macOS Catalina
Libre Office 6.2.8.2
I have a macro that is to filter a listbox on the sting that is in the previous field. I have had this code working in a previous version but I have had to add another form at the top so the Table control is now on subform3.
Macro Name “RefreshListCategory”
Form is form_Date_Entry
Table control is at the bottom of the form
Fields are, Name. Category. Sub_Category. Product, Vol, Currency, Value
The Name is ok so is Category, The macro is set to run when I lose focus of “Category” but it stops at sSelectedValue = oColumn.SelectedValue
This is meant to select the sting in “Category” so that the next step can filter the query and only return “Sub_Category” possibilities where the Category sting equals options in the query qry_Listboxes.
Once it is working between Category & Sub_Category. I also need it to work between Sub_Category & Product & Product & Vol
Please ignore the mess at the top of the form I haven’t got round to formatting it correctly yet.