Kirk,

Glad you found a solution ... I had been thinking about suggesting using a DataView, however, it *should* work with a DataTable, so I'm still not sure why it wasn't working that way.

~~Bonnie


>I gave up and went to the VFPTOOLKIT...wow, it all worked.
>
>New Code:
>
>

>       'Create a Connection
>        Dim oConn As System.Data.OleDb.OleDbConnection
>        oConn = SqlConnect(gcConnString)
>
>
>        Dim lcSQL As String
>        lcSQL = "Select deptdesc,deptid from coDept where isactive=1 order by Deptdesc"
>        Dim goView As New Data.DataView()
>
>        goView = VFPToolkit.vfpData.SqlExecute(oConn, lcSQL, "Departments")
>
>        Me.ComboBox1.DataSource = goView
>        Me.ComboBox1.DisplayMember = "deptdesc"
>        Me.ComboBox1.ValueMember = "deptid"
>