I am using also the Base Form feature "Data Source as Table". And my questions has been related to the displayed table.
In its early days Star Office, the predecessor of OpenOffice, had a feature known as the "beamer". I suspect the current GUI still makes use of some relic coding to display "Data Source as Table". It would probably require a macro starting with the
StarDesktop service to change the selection and order of rows or columns to be displayed.
If the requirement is the automatic display of the Data Source Table,
UnklDonald418's suggestion to add an extra
data form to the
form document is the simpler route: that data form containing a grid
form control can readily be programmed to display and sort whatever rows or columns are required from the Data Source: in particular,
display the table whenever I open the form
control the size of the table in my form
control which columns are displayed
control the order of the columns
This added data form can be linked or not, as wished, to the other data form(s) contained in the form document.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
AOOo 4.1.5 & LO 6 on MS Windows 10 MySQL and HSQLDB