ComboBox passing values from selected

A

Angel G

In my form (Items_frm) I have a combo box (Itemcbx) that displays 4 columns
(Item, Makebuy, Revision, IsActive) but is bound to the first column.
However, I would like to pass the other values from the remaining columns to
other fields in my form after the selection. Is this possible?
Can someone provide a sample code?
 
G

Guest

You can use the Column() attribute.

Me.Itemcbx.Column(1) etc.

Note that the index for combo box columns is zero-based so 0 is the first, 1
is the second and so on...

Steve
 
A

Angel G

Beautiful!

It works nice!!!
Thank you so much.


SteveM said:
You can use the Column() attribute.

Me.Itemcbx.Column(1) etc.

Note that the index for combo box columns is zero-based so 0 is the first,
1
is the second and so on...

Steve
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox custom forecolor 2
Need combo box to refresh when moving to new record 2017 1
Lookup current record with ComboBox, any changes create new record 3
incorrect null value in combobox 5
Passing control values 8
Multicolum filter combobox 2
Passing Values from One Form to Another Including a Combo Box 7
Passing rowsource to combo box without nulls. 2

Top