C
coilerDH
Guest
I have a data bound combo box. The combo box is being used to show first names from a sql server table. The combo box is showing the first names fine. When the form is run, the first entry on the table is displayed in the combo box. The problem begins when pulling down the combo box tab and selecting a name. The first name displayed when the form is run gets replaced by the following user choice and will not return. After that, continuing to select names jumbles up the combo box order. Theses changes are not reflected on the back end because Im not saving back to the database. Im sorry if this is confusing, Im going my best to explain.
Recap:
7 first names. The form starts. Name 1 is shown. I make a selection from the combo box, say name 5. Name 1 has now been replaced with name 5 ("replaced" meaning no longer listed in the drop down list of the combo box). There are now two name 5s in the combo box. At this point forward, name 1 will not return. The name currently being shown in the combo box will now be replaced by the next selection (in the list, not the text box part of the combo box). Very quickly, after making selections from the drop down list, the names in the combo box look nothing like the first name column of the sql table. They are out of order and there are two of a first name at any point. This all resets when the form is restarted.
Continue reading...
Recap:
7 first names. The form starts. Name 1 is shown. I make a selection from the combo box, say name 5. Name 1 has now been replaced with name 5 ("replaced" meaning no longer listed in the drop down list of the combo box). There are now two name 5s in the combo box. At this point forward, name 1 will not return. The name currently being shown in the combo box will now be replaced by the next selection (in the list, not the text box part of the combo box). Very quickly, after making selections from the drop down list, the names in the combo box look nothing like the first name column of the sql table. They are out of order and there are two of a first name at any point. This all resets when the form is restarted.
Continue reading...