I have a combo box that displays all the US states - it displays the full state name and the value member is the postal abbreviation. I can see the data in the table in SQl Server and in th BO when I step through the code. But the state does not display in the combo unless I edit the record in the UI and save it. What is up with this?

Thanks

Hi Ivan.

Actually, it is not a states table I have a pair of tables called lookup_hdr that contains all the categories for the various lookups used in the app and lookup_det that contains all the lookup detail items for each category. No, the state abbreviation is not the PK in lookup_det - I never use keys that contain business information.

The odd thing is that I have combos set up in exactly the same way in other forms in the application and it works just fine in the other forms This one had a bug in it earlier - the combo was set up incorrectly and was using the PK as the value member but the field in the table it was trying to update was a VARCHAR. I wonder if this has something to do with it, but if it does, I have absolutely no idea of how to fix it.