Combo Box Problems 1

[ninash]

Hi All

I have a combo box on a form that contains 3 columns,
2 of these columns are for user information and the 3rd is a reference I require in another field on the form.

However I don't know how to tell the field to access that column for the selected value in the combobox.

Can someone please help me?

Regards
Tony

 

[RoyVidar]

You can reach any column of combos and lists for the selected item thru their column property:

[tt]=mycombo.column(2)[/tt]

as controlsource of a control, would return the third column of the combo (zero based), or use the after update event of the combo:

[tt]me!txtSomeBox.value=me!mycombo.column(2)[/tt]

Roy-Vidar

 

[ninash]

Thanks Roy

 

[BobStubbs]

Here is an example for a two-column combo box:

    EmployeeID = cmbNewEmployee.Column(0)
    EmployeeListName = cmbNewEmployee.Column(1)

Here I am setting the field EmployeeID to the value in the first combo box column - note that this is numbered 0. EmployeeListName is set to the second column.

This technique allows you to get to individual column values from a combo box. Put this type of code in the combo box's On Exit or On Lost Focus event, or on a [Set Values] button etc.


Bob Stubbs