[SOLVED] How to display bound column in ComboBox when form loads in vb 2010 Express

[DexterRose]

I am new to VB 2010.
I have set the properties of the combobox as below:

I have a ComboBox whose Display Source is set to "Managers Binding Source" and Display Member is set to "Manager Name".
Under DataBindings I have the Text property set to "Salesperson Binding Source - SalespersonManager".

When I select a manager name in the comboBox the Salesperson database is updated with the newly selected Manager Name just fine.

My problem is, when the form loads the next time, the ComboBox shows the first Manager in the Display Member list INSTEAD OF THE MANAGER THAT THIS COMBOBOX IS BOUND TO.

How do I get the bound column to display in the combobox instead of the first member of the Display Mamber list??

[dunfiddlin]

The ComboBox is BOUND to a list of values that is initialised when the form loads. Selections don't carry over as if by magic. If you want a particular item to be the first that is seen then you must save that setting in some way and apply it again when the form loads or you must hide the form rather than closing it.

[DexterRose]

I had tried adding a separate bound Textbox and setting the ComboBox.text = Textbox.text and this worked fine but I thought there had to be a better way. Wasn't a problem in VB5.

[dunfiddlin]

Wasn't a problem in VB5.

If you'll forgive the pun, I suspect that's the Rose coloured spectacles talking! It's not a problem introduced by .Net. It's not a problem at all, in fact. As I said, it's simply that a form will inevitably reinitialise every time it goes through a full load.

[wes4dbt]

Just dealt with this problem yesterday. I found you must "Fill" the datatable for the combobox datasource (listitems) before you "Fill" the datatable that the combobox is bound to, in your case the Salesperson.

[DexterRose]

Well, are you not the HERO!!

I switched the order of the "TableAdapter.Fill" code in the Load Event, and wala, the ComboBox performs as you would think it should!!!!!!!

It would really be nice if MS would put info like this in their documentation of their controls.

Thanks again!!

[jmcilhinney]

I switched the order of the "TableAdapter.Fill" code in the Load Event, and wala, the ComboBox performs as you would think it should!!!!!!!

Just so you know, there's no such word as "wala". It's "voila", which is French for (if memory serves) "there it is".