Cryptic List Box Problem

[cstanley]

Here's a wierd one -

I have a list box in a form, displaying two fields (a number and a title). When the form is not set for data entry, it transfers both fields that are selected into a table. When the form is set for data entry, it only transfers the number data, leaving the title behind. I would like to be able to set the form for data entry. I know there must be a simple solution to this... please help!

Thanks,

Chris

 

[David R]

Your table _should_ be storing the number data, not the text title, anyway. That way if a title ever changes from "Grand Poobah" to "Grand Pooba", you won't have to go through 457 records to change them all individually. Change the one record in the linked table and all will be well.

Now, if you want to make sure you see the text value, include that lookup table in your query and drag in the text field, not the number field. As long as the relationship is right this will work invariably. (it probably works sometimes now because you used the lookup wizard to assemble that field, I'm guessing).