<div>
<div class="content wysiwyg-content">
Set rs = Myconn.Execute(&quot;SELECT DBName FROM DBRecords WHERE DBName LIKE '*&quot; &amp;&nbsp;&quot;fan_&quot; &amp;&nbsp;&quot;*'&quot;)<br />
&nbsp; &nbsp; If Not rs.EOF Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; cboLoadDB.AddItem rs.GetString<br />
&nbsp; &nbsp; End If<br />
rs.Close<br />
Set rs = Nothing
</div>
</div>


Set rs = Myconn.Execute("SELECT DBName FROM DBRecords WHERE DBName LIKE '*" & "fan_" & "*'")
    If Not rs.EOF Then
        cboLoadDB.AddItem rs.GetString
    End If
rs.Close
Set rs = Nothing

How do you populate a combobox from a certain column and that only has &quot;fan_&quot; somewhere in the text?

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.

How do you populate a combobox from a certain column and that only has &quot;fan_&quot; somewhere in the text?

How do you populate a combobox from a certain column and that only has "fan_" somewhere in the text?