Iif statements that return a value from a list box

[Bill F]

When I write the Iif statement the value returned is the ID number of the
item in the list box but not the value. How do I get the actual value
returned in my expression?

 

[Ian C]

Bill, you need to refer to the appropriate column of the list box.

iif(x=y,[listbox_name].[column](1),"nothing")


where column(1) is the second list box column, and (0) the first.