Hi,

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:
RowSourceType: Table/Query
Row Source: ddQry
ColumnCount: 2
Column Widths: 0";2"

The results of the query are of the form:

1, Orange
2, Mint
3, Lemon

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.

Any thoughts?

Thanks,

Jerry

Is this a linked table or a data connection/recordset? Is this a local query you are looking up, or a SQL view?

Still ruminating...

mmcdonal

The table referenced in the query is linked to the SQL database.

Also, I make this happen in trivial form that just has a combo box and a query to a linked table.

Any insight is greatly appreciated.

jerry

Also, the query runs against the linked table, not against a view.