Is it possible at all?
The scenario:
In a Access 2019 FE with no linked table to it's SQL server BE, I want to set the row source of a combo box to a sql server table. Of course without having a linked table.
I know that I can set combo box's Row Source Type to List Value, read the data from table and add the items one by one.
But it's not convenient for me. I need to set the Row Source.
Thanks for any kind of advice.
The scenario:
In a Access 2019 FE with no linked table to it's SQL server BE, I want to set the row source of a combo box to a sql server table. Of course without having a linked table.
I know that I can set combo box's Row Source Type to List Value, read the data from table and add the items one by one.
But it's not convenient for me. I need to set the Row Source.
Thanks for any kind of advice.