filling list box from table

[dreamdelerium]

hi everyone, i got a question
in my forms i have a control that has two columns, one with text the other with a value (ie value1;0;value2;1...etc). when it gets saved to a table, i only save the value not the text (0,1...). now, when i want to load the data from this table to the forms listbox i dont want to display the number but rather the text. how can i accomplish this?

thanks for your help
jason

 

[missinglinq]

i have a control that has two columns, one with text the other with a value (ie value1;0;value2;1...etc). when it gets saved to a table, i only save the value not the text (0,1...). now, when i want to load the data from this table to the forms listbox i dont want to display the number but rather the text.

I'm sorry, but your post really makes little sense. If you're not saving the text to your table, how could you possibly turn around and load the text it from the table to your Listbox?

 

[dreamdelerium]

oh, i forgot. i have a lookup table with all the values and coresponding text.