Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have 2 listbox. As listbox1 and listbox2.
listbox1 having values like a,b,c and listbox1 having values like 1,2, 3 respectivaly
If i click on "a" then want output in text box as like 1
If i click on "b" then want output in text box as like 2
If i click on "c" then want output in text box as like 3
Thanks in advance
--Regards,
Villyee
try with this expression in your text box:
=if(only(abcField)='a', 1, if(only(abcField)='b', 2, if(only(abcField)='c', 3)))
abcField is the name of the field used in your listbox1.
Marc.
May be like this? PFA
Best,
S
List box will work with data association, so if that's the relationship between Field 1 and Field 2 then it will populate that.