Here's the problem. I have a datacombo bound to an ADO Control bound to an Excel sheet. Everything works fine, except that I want to be able to reset the datacombo such that the first thing listed is once again listed in the box (i.e. reload the datacombo) I've tried a few things that seem to work just fine within the IDE, but once I compile, they don't reset the text in the datacombo at all. What's going on?
The first thing listed in the datacombo is "Select State"
then the user selects from a list of states provided by the excel sheet
But if the user presses a refresh button, I want to be able to revert the text back to "Select State"
I'm not sure why I can't get this to work outside of the IDE