Combo Box List Not Updating As Desired

I have a main form that contains a combo box bound to a field in the main table of a database. That combo box gets its selection list from another table (call it ListTable) in the database, and there is a second form (call it ListForm) that can be opened to allow the user to populate the ListTable manually. The problem is that when I add items to the ListTable from this ListForm, when I close the ListForm, the combo box selection list does not contain the newly added items; I have to close and relaunch the application for the updated items to appear.

What do I need to do to have the selection list for the combo box refreshed upon closing the ListForm, so that the newly added items are available immediately I know there is a way to do it, but as an absolute beginner, I can't seem to reason it out. Some time ago, I had a program that did this same thing, and it had a "refresh" button that updated the selection list. I'd settle for doing it that way, but surely there's a way to do it automatically, right

Hopefully someone can explain why this is happening as well as providing some code.

Thanks in advance.

Answer this question

Combo Box List Not Updating As Desired

D_niit
In your main form load event you should have a line of code similare to this

Me.ListTableAdapter.Fill(Me.MyAppDataSet.List)

This is loading your list into memeory. When you update the list via the List form you are updating the database but not the table adapter copy in mememory. You need to add another call to the above line to refresh the table adapter after you close the List form. If you are opening the ListForm with a ShowDialog() you can add it right after the showdialog line.
Sreenidbl
Man! Forgive me for getting so excited, but that was absolutely awwwwesome! The explanation made perfect sense so that I was able to understand the concept behind the code, which beats just plugging in gibberish that happens to work.
When I first put in the code, it didn't work, but I could study it and see why, so I made the proper correction and now it works perfectly.
Thanks.
Combo Box List Not Updating As Desired

Answer this question