Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 5 list box,
Office Head,
Dept head,
VP name,
Org head
Location Head.
I want to show name in a text box based on the selected listbox.
For eg: if user choose Dept head text box should show that, if user chooses Org head text box should show that and so on.
What should be shown if a user makes selections in multiple list boxes?
User will not select multiple listbox at same time. But basically the the list that is selected only that value/values should appear in textbox
You can try with a Text Box expression like this:
= IF (GetSelectedCount([Office Head]) > 0, 'Office Head',
IF (GetSelectedCount([Dept head]) > 0, 'Dept head',
IF (GetSelectedCount([VP name]) > 0, 'VP name',
IF (GetSelectedCount([Org head]) > 0, 'Org head',
IF (GetSelectedCount([Location Head]) > 0, 'Location Head', 'None')))))
Best,
Peter
Hi,
maybe one solution could be:
SubField(GetCurrentSelections(),':',1)
hope this helps
regards
Marco