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
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