select the item of the second column

[patweb]

For my code I need the value from a combobox. This combobox is based on a table and consist out of two columns. The first column is the ID and the second is the name of the branch. When asking the value he give the ID. How to get the value of the second column ?

strBranch = Forms![F-01-FIRM]![BRANCH]
msgbox strBranch = 1
should be msgbox strBranch = "a branch name from the second column"

Certainly an easy one.

Thanks for your prompt answer. Pat

 

[illini]

Try the following...

strBranch = Form_F-01-FIRM.BRANCH.column(1)

Let me know if it works.

-illini

 

[patweb]

Thats it, now I see it, if you don't us it frequently you forget it.

strBranch = Forms![F-01-FIRM]![BRANCH].Column(1)
strBRanch = "a name of a branche"