Pulling Multiple Columns from a Combo Box

[Jourdan]

I have a form with several combo boxes in it.

The combo boxes have columns titled:
BulletID, BulletPoint, Rating

When a user selects the BulletPoint they want, that BulletPoint is
entered into a table.

I want that to continue to happen and to have "Rating" iserted into
another table.

Any suggestion?

[Ron2006]

Into another "Table"? or another field?

you can reference the other fields of a combo as follows

me.comboboxname - points to the bound column what
ever it is.

me.comboboxname.column(0) - points to first column of data
(bulletID)
me.comboboxname.column(1) - points to second column of data
(bulletPoint)
me.comboboxname.column(2) - points to third column of data
(bulletRating)

etc

[Bob Quintal]

"Jourdan" <ex******@msn.com> wrote in
news:11**********************@i40g2000cwc.googlegr oups.com:

I have a form with several combo boxes in it.

The combo boxes have columns titled:
BulletID, BulletPoint, Rating

When a user selects the BulletPoint they want, that
BulletPoint is entered into a table.

I want that to continue to happen and to have "Rating" iserted
into another table.

Any suggestion?

You have to use the combobox.column() property to get the value.

From ACC2K3 help:
expression.Column(Index, Row)

expression Required. An expression that returns one of the
objects in the Applies To list.

Index Required Long. A long integer that can range from 0 to
the setting of the ColumnCount property minus one.

Row Optional Variant. An integer that can range from 0 to the
setting of the ListCount property minus 1.

Remarks
Use 0 to refer to the first column, 1 to refer to the second
column, and so on. Use 0 to refer to the first row, 1 to refer
to the second row, and so on.

--
Bob Quintal

PA is y I've altered my email address.