Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
This one's more serious
I need help with this syntax... I have been able to successfully load my
ComboBox from a SQL Server Recordset. However, I am only getting one column in my combo box, and I need both columns from the recordset to show. Can one of you masters show me what is wrong with my code, or how to tweak it to make the combo box load both columns of my query. 'Set Up cmbxCustomerSelection With cmbxCustomerSelection .ColumnCount = 2 .BoundColumn = 2 .TextColumn = 1 End With 'Load cmbxCustomerSelection Do While Not adoRsA.EOF cmbxCustomerSelection.AddItem adoRsA(0).Value adoRsA.movenext Loop Much appreciation! DBAL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables are showing One's where real value should be | Excel Discussion (Misc queries) | |||
Can AutoSave's default settings be changed to one's preference? | Excel Discussion (Misc queries) | |||
Match, Copy, Merge, Delete and Repeat... MVP's this one's for you. | Excel Discussion (Misc queries) | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
can one write one's own Excel Function? | Excel Programming |