Listbox Control

[fenhow]

Hi,

I have a listbox on my form that is calling data from a table that has option values in it 1, 2, 3 etc..

I am using this code on my form to convert the numbers into words

=IIf([si_Permitting_Status]=1,"Permit Assigned",IIf([si_Permitting_Status]=2,"Permit Pending etc...

is there anyway to do this for that column on my listbox?

I tried to add this to the query that the LB uses to populate but i could not get it to run.. or work..

Thanks.

Fen How

 

[missinglinq]

What happens, in the future, if you need to change the wording of the status explanation or add a new status? The sensible thing would be to have the explanations as a second field in the table that the listbox pulls from and use this field as the second column in it. Then, if you need to make changes, you simply do it in the table, rather than having to go back in and modify the code.