Combo Box Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Pockmire - 17 Mar 2005 13:43 GMT

I have a combo box on a form that uses multiple columns from a query as it's
recordsource. How can I acces the data in the columns other than the bound
column?

Reply to this Message

Nikos Yannacopoulos - 17 Mar 2005 14:00 GMT

Jim,

While Me.cboName returns the value of the bound column,
Me.cboName.Column(i) returns the value of column i (where the first
column is 0 and the last one is n-1, if n columns in total).

HTH,
Nikos

> I have a combo box on a form that uses multiple columns from a query as it's
> recordsource. How can I acces the data in the columns other than the bound
> column?

Reply to this Message

Allen Browne - 17 Mar 2005 14:02 GMT

Use the Column() property of the combo.

The first column is counted as zero, so the 2nd column of a combo named
Combo1 would be:
[Combo1].Column(1)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a combo box on a form that uses multiple columns from a query as
>it's
> recordsource. How can I acces the data in the columns other than the bound
> column?

Reply to this Message