Hi,

Can someone please help with this problem I'm having.

I have an Access DB, I know how to retrieve data from it, but I can't for the life of me pick the data from an adjacent column to the number selected in the Combobox.
So if I select 147852 in the Combobox, I would like the Description textbox to show the description, i.e. "Garden"

Screenshot 2025-02-05 224739.png

Screenshot 2025-02-05 224102.png

This is the code I'm using to get the information from the "Number" column in the DB
    
    Set cn = New ADODB.Connection
    Set rs = New ADODB.Recordset
    
    With cn
        .Provider = "Microsoft.ACE.OLEDB.12.0"
        .ConnectionString = "Data Source = " & ThisWorkbook.Path & "\Db\DB.accdb"
        .Open cn
    End With

    SQL = "Select * from Master_List"
    rs.Open SQL, cn, 1, 3

    Dim PNumber As Variant
    PNumber = rs.GetRows(Fields:="Number")
    cbNumber.List = Application.Transpose(Number)
    
    ' Need help with filling in the textbox for Description
    txtDescription = ????
I'm sure it's fairly simple, but can't think at the moment

Thanks