I have this form in form_load to set the value list of a combo box
I have code to display the rowsource for the combobox when I double click it.
The rowsource becomes this:
"-32768";"Form";"-32766";"Macro";"-32764";"Report";"-32761";"Module";"1";"Table";"4";"Table_ODBC";"5";"Query";"6";"Table_Lnk";"WKS_Set"
The original code was more complex, the above is my attempt to simplify it as much as possible.
I have tried a number of things including a decompile, deleting the combo box and recreating it. Changing the order, changing the value of WKS_Set, nothing helps. Using semicolons everwhere, using quotes,not using quotes. Nothing has helped. Access just keeps dropping the value associated with WKS_Set.
Anybody seen this? Am I overlooking something obvious?
Code:
Dim strList As String
strList = "-32768,Form;-32766,Macro;-32764,Report;-32761,Module;1,Table;4,Table_ODBC;5,Query;6,Table_Lnk;-30000,WKSSet;"
Me.cboObjectType.RowSource = strList
The rowsource becomes this:
"-32768";"Form";"-32766";"Macro";"-32764";"Report";"-32761";"Module";"1";"Table";"4";"Table_ODBC";"5";"Query";"6";"Table_Lnk";"WKS_Set"
The original code was more complex, the above is my attempt to simplify it as much as possible.
I have tried a number of things including a decompile, deleting the combo box and recreating it. Changing the order, changing the value of WKS_Set, nothing helps. Using semicolons everwhere, using quotes,not using quotes. Nothing has helped. Access just keeps dropping the value associated with WKS_Set.
Anybody seen this? Am I overlooking something obvious?