I am trying to use a DBCombo box.
It reads a Access.mdb table with only one field.
It works fine when I bind it to a Data ocx object on the form. It works fine, that is, as long as I set the Properties of the Data ocx object to:
DatabaseName = Access.mdb full path (Ex. C:\etc.)
DefaultCursorType = DefaultCursor
DefaultType = UseJet
This is not what I need.
What I need to do is access the Access.mdb via ODBC but when I set the Properties of the Data ocx object to:
DatabaseName = the ODBC name
DefaultCursorType = ODBCCursor
DefaultType = UseODBC
It does strange things. It displays only the first letter of the field in the DBCombo box and it loses the drop down list.
I need to use the ODBC cannection, any advice?
Thanks!
It reads a Access.mdb table with only one field.
It works fine when I bind it to a Data ocx object on the form. It works fine, that is, as long as I set the Properties of the Data ocx object to:
DatabaseName = Access.mdb full path (Ex. C:\etc.)
DefaultCursorType = DefaultCursor
DefaultType = UseJet
This is not what I need.
What I need to do is access the Access.mdb via ODBC but when I set the Properties of the Data ocx object to:
DatabaseName = the ODBC name
DefaultCursorType = ODBCCursor
DefaultType = UseODBC
It does strange things. It displays only the first letter of the field in the DBCombo box and it loses the drop down list.
I need to use the ODBC cannection, any advice?
Thanks!