Access combo box does not work with SQL Server
I am migrating an Access Application to an SQL Server. One of the issues I have run into is that my combo boxes do not work correctly.
The combo box is unbound and uses a query to populate it's contents. The query (called ddQry) is of the form:
SELECT ID, NAME from tblCode where codetype='flavor'
The relavent properties on the combo are:
Row Source: ddQry
Column Widths: 0";2"
The results of the query are of the form:
What happens is when tblCode is an Access table, the combo box works as expected. However, when I migrate the table to SQL server, all items show up when you drop down the list, but after you select one the combo is empty. Also, if you change the column widths to display the first column the values do show after selection, but as expected just the number is displayed.