<div>
What is the refresh button code doing? &nbsp;My first thought is that the recordset cursor is not being moved. &nbsp;Have you tried adodc.recordset.movefirst in the Refreshbutton_click event code? &nbsp;
</div>


What is the refresh button code doing?  My first thought is that the recordset cursor is not being moved.  Have you tried adodc.recordset.movefirst in the Refreshbutton_click event code?  

<div>
That's exactly what I ended up doing.
</div>


<div>
<div class="content wysiwyg-content">
Here's the problem. &nbsp;I have a datacombo bound to an ADO Control bound to an Excel sheet. &nbsp;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) &nbsp;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. &nbsp;What's going on?<br />
<br />
For example....<br />
<br />
The first thing listed in the datacombo is &quot;Select State&quot;<br />
<br />
then the user selects from a list of states provided by the excel sheet<br />
<br />
But if the user presses a refresh button, I want to be able to revert the text back to &quot;Select State&quot;<br />
<br />
I'm not sure why I can't get this to work outside of the IDE
</div>
</div>


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?

For example....

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

Manipulating DataCombo Box at Run Time

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.