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

Is the Postal Abbreviation the PK for the State's table?

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.

Hi Trent.

No - this is not it. As I navigate through the records, the combo appears blank but the property in the BO has the correct value. Please see my response to Ivan if it will help you to guide me through this stupid problem

Also, my response may change a bit if you are manually setting the DataSource, DisplayMember, and ValueMember or the SF population settings.

One other thing to check, if you are using the SF population, then be sure that the DisplayMember in the PopulationDataSourceSettings is set to a value and not empty...that can produce an empty combo as well (i.e. {0}, {1}, etc.)

The thing that is really goofy is that I have combos set up exactly the same way in other forms and they work just fine. I even added this line of code in the boParticipant_Navidated event handler:

I have been trying to tell you how I solved this but I keep getting this error when I try to post the response:

The board administrator has requested that you must provide some message content within your post. You cannot post only HTML, Images, EmotIcons or IFCode.

OK - here goes When all else fails, try a bigger hammer - this code in the boParticipants_Navigated eventhandler solved the problem, but I have no idea why it was necessary in this one case:

cbostate_nme.SelectedValue = boParticipants.state_nme.Trim();
boParticipants.CurrentDataTable.AcceptChanges();