I have the following query as the row source for a combo box.
SELECT DISTINCT Qry_OrdersOverdueList.CustomerTitle, Qry_OrdersOverdueList.AccountingRef
ORDER BY Qry_OrdersOverdueList.CustomerTitle;
It works fine with Access linked tables but as soon as I moved the tables to SQL server and link via ODBC I get the following error.
ODBC-- call failed
[Microsoft][ODBC SQL Server Driver][SQL Server] ORDER BY items must appear in the select list if SELECT DISTINCT is specified. (#145)
Qry_OrdersOverdueList.CustomerTitle appears in the select list so I can't figure it out.
Any help greatly appreciated.