I have a bound combobox on a windows form, which needs to show the most recent data in the database when the user drops down to select values. I've done this before in a datagridviewcombobox control by using the 'begin edit' and 'end edit' events. The stand alone combobox does not have those events, so which event would be best to use, to seamlessly show the user the most recent data?

I have tried the 'Enter' event, but if you just click on the combobox, it flashes (not on my machine, but on a slower XP machine). It flashes the values enough to be annoying to the user... I have also tried using the drop down event, but the code I was using was not allowing the drop down event from finishing because I could not get the control to drop down. I also have code in the selectedIndexChanged event, to populate other fields ont he screen based on the user's choice, so the code I need to write needs to refresh the combobox without 'changing the index' to somthing other than 0... To fix this I save the selectedIndex, reload the data, and reset the selected index... which just now I realized that that won't work because the order of the data could change, and the selected index might be different.. I need to base off the value.... Anyhoo, this is what I use now, on the 'Enter' event which causes the control to flash..

_transactionsIndex = cboTransactions.SelectedIndex;
transactionTableAdapter.FillBy(_dtTransactions);
cboTransactions.SelectedIndex = _transactionsIndex;

So, any ideas on which event I need to use to get the most recent data available to the user, when they click the box? Again, this screen adds items all the time, and other screens might add data to the list...

Thanks,

Brandon