<div>
cbo1.additem &quot;whatever&quot; is the correct syntax
</div>


cbo1.additem "whatever" is the correct syntax

<div>
<br />
The following worked perfect. I still appreciate your input.<br />
<br />
<br />
Dim conn<br />
Dim rec<br />
<br />
<br />
Set conn = New ADODB.Connection<br />
Set rec = New ADODB.Recordset<br />
conn.Open &quot;Provider=Microsoft.Jet.OL<wbr />EDB.4.0;Da<wbr />ta Source=C:\Database.mdb;Per<wbr />sist Security Info=False&quot;<br />
esql = &quot;select Distinct STATE from Dataset&quot;<br />
rec.Open (esql), conn, adOpenStatic, adLockReadOnly<br />
If rec.RecordCount &gt;&nbsp;0 Then<br />
&nbsp; &nbsp;rec.MoveFirst<br />
&nbsp; &nbsp; Do Until rec.EOF<br />
&nbsp; &nbsp; &nbsp; &nbsp; FacilitySelection.CmbState<wbr />.AddItem rec(&quot;STATE&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; rec.MoveNext<br />
&nbsp; &nbsp; Loop<br />
End If<br />
conn.Close<br />
Set conn = Nothing
</div>



The following worked perfect. I still appreciate your input.


Dim conn
Dim rec


Set conn = New ADODB.Connection
Set rec = New ADODB.Recordset
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Database.mdb;Persist Security Info=False"
esql = "select Distinct STATE from Dataset"
rec.Open (esql), conn, adOpenStatic, adLockReadOnly
If rec.RecordCount > 0 Then
   rec.MoveFirst
    Do Until rec.EOF
        FacilitySelection.CmbState.AddItem rec("STATE")
        rec.MoveNext
    Loop
End If
conn.Close
Set conn = Nothing

<div>
<div class="content wysiwyg-content">
HOw can I populate a combobox in vb with data from a field in a database. The query I want to use is &quot;Select distinct(&quot;Field1&quot;) from dbTable&quot;<br />
<br />
I want to know how to open the database and get the data into combo.<br />
<br />
Thank you.
</div>
</div>


HOw can I populate a combobox in vb with data from a field in a database. The query I want to use is "Select distinct("Field1") from dbTable"

I want to know how to open the database and get the data into combo.

Thank you.

population combo with database values.

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.