Populate multicolumn combobox

  • Thread starter Thread starter icccapital
  • Start date Start date
I

icccapital

I found some articles for excel comboboxes that say to fill an array and then
assign the array to myCombobox.List = myArray, but in access there is no list
property for a combobox. Access help talks about using the column property to
populate the combobox, but all the ways I have tried give me errors.

Is there an easy way to do this?

Thanks
Access 2007
 
I found some articles for excel comboboxes that say to fill an array and then
assign the array to myCombobox.List = myArray, but in access there is no list
property for a combobox. Access help talks about using the column property to
populate the combobox, but all the ways I have tried give me errors.

Is there an easy way to do this?

Thanks
Access 2007
Click to expand...

By far the most common way to manage the data in a combo box (or listbox) in
Access is to base it on a Query. The query can have multiple fields (which
will show up as columns when the combo is dropped down); you can change the
data displayed in the combo by changing the criteria of the query or by
editing the data in the table.

What specifically are you trying to accomplish? What do you want the combo to
show?
 
I think I realized my mistake. I have a form with a bunch of bound controls
on it. One of those was a combo box that pulled data from one table and yet
was bound to the field of a linked table. I am changing the form so that it
is all unbound so I can manage the updating of the database differently and
I was trying to unbind the combobox by filling it in VBA. But I realize now
that I should just have the rowsource still be the table, but remove the
bind.

Really stupid. Thanks for the thoughts and the time.
 
Back
Top