filter data into combo box

[Playmaker]

Hi, I need help with something. I have a combo box connected to a table in my SQL database using ADODC. What I want is to display only certain data from that table into the combobox. The data is dependant on which client number is on the form. Is there a way to filter which data choices populate my combo box according the client number specified in a text box on my form?

Thanks.
Eddie

[Clunietp]

Hi Eddie. Here is some code I whipped up for you. This uses the CUSTOMERS table in the NORTHWIND mdb:

Private Sub Combo1_DropDown()
    
    'declare objects
    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset
    
    'clear existing list
    Combo1.Clear
    
    'open recordset of data that we want to get, using the current customer id
    rs.Open "Select * from Customers where CustomerID = '" & Me.Adodc1.Recordset.Fields(0).Value & "'", Me.Adodc1.Recordset.ActiveConnection
    
    'populate dropdown box
    Do Until rs.EOF = True
        Combo1.AddItem rs.Fields("CompanyName").Value
        rs.MoveNext
    Loop
    
End Sub

Tom