multi column combobox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mcnews - 15 Oct 2007 15:18 GMT

i can't seem to figure out how to load a multi column combo box that
is configured to use a value list.
AddItem works fine for the first column, but ItemData, NewList, List
etc don't seem to work as expected.
any clues would be appreciated.
tia,
mcnewsxp

Reply to this Message

Douglas J. Steele - 15 Oct 2007 16:23 GMT

How are you using AddItem?

If you've got a 3 column combo box, for example, you need to use:

Me.MyComboBox.AddItem "ValueForColumn0;ValueForColumn1;ValueForColumn2"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>i can't seem to figure out how to load a multi column combo box that
> is configured to use a value list.
[quoted text clipped - 3 lines]
> tia,
> mcnewsxp

Reply to this Message

mcnews - 15 Oct 2007 16:49 GMT

On Oct 15, 11:23 am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

> How are you using AddItem?
>
[quoted text clipped - 11 lines]
> > etc don't seem to work as expected.
> > any clues would be appreciated.

ah, semicolon.
i new there had to be a way.
i tried a comma.....
thanks,
mc

Reply to this Message