I have a combo box on a form (MainForm) that's bound to a column in a database table. I want this combo box to get it's list of selections from a second table (LocationsTable). Items are added or deleted from LocationsTable via a second form (frmLocations).
If I have MainForm open and I then open frmLocations to say, add a new location, the LocationsTable is updated properly, but when I close frmLocations, the Combo Box on the MainForm doesn't reflect the updated selections. frmLocations is modal and I added a "Done" button to close it.
Since I am teaching myself C# (sorry, can't afford to pay for college or a course), I'd like to figure this out on my own, but I have wrestled with it for 7 straight hours so far! It would help if someone can tell me if I am thinking about this correctly, and if not, how to solve this. Here's what I THINK:
I think I should add code behind the "Done" button on frmLocations that will refresh the combo box on the MainForm. If that's correct, I could use a hint on what code to use. If that's NOT correct, then I am completely lost on this concept and would appreciate some help!