Iif statements that return a value from a list box

  • Thread starter Thread starter Bill F
  • Start date Start date
B

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?
 
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.
 
Back
Top