J
JT
Tom.........thanks for all of the help with comboboxes. I
haven't used them in a form before and I'm finding that
this has been quite a challenge
I've modified your suggested code to populate the combo
box. This is what I'm using
With ComboBox1
.AddItem CustNum.Value
.List(.ListCount - 1, 2) = Me.Controls("custnum").Value
.List(.ListCount - 1, 3) = Me.Controls("docnum").Value
.List(.ListCount - 1, 4) = Me.Controls("unitnum").Value
.List(.ListCount - 1, 5) = Me.Controls("expacct").Value
.List(.ListCount - 1, 6) = Me.Controls("expbr").Value
.List(.ListCount - 1, 7) = Me.Controls("amt").Value
.List(.ListCount - 1, 9) = Me.Controls("descr").Value
End With
CustNum is the first textbox the user enters data in.
However, when I click on the drop down box, I can see all
of the items in the various columns. However, when I
select a row in the combobox, only the first field is
displayed.
What can I do to display the data in all of the columns?
Any good sources for learning about comboboxes? Thanks
for all of the help, I really appreciate it.
haven't used them in a form before and I'm finding that
this has been quite a challenge
I've modified your suggested code to populate the combo
box. This is what I'm using
With ComboBox1
.AddItem CustNum.Value
.List(.ListCount - 1, 2) = Me.Controls("custnum").Value
.List(.ListCount - 1, 3) = Me.Controls("docnum").Value
.List(.ListCount - 1, 4) = Me.Controls("unitnum").Value
.List(.ListCount - 1, 5) = Me.Controls("expacct").Value
.List(.ListCount - 1, 6) = Me.Controls("expbr").Value
.List(.ListCount - 1, 7) = Me.Controls("amt").Value
.List(.ListCount - 1, 9) = Me.Controls("descr").Value
End With
CustNum is the first textbox the user enters data in.
However, when I click on the drop down box, I can see all
of the items in the various columns. However, when I
select a row in the combobox, only the first field is
displayed.
What can I do to display the data in all of the columns?
Any good sources for learning about comboboxes? Thanks
for all of the help, I really appreciate it.