VBA To Populate Textbox From SQL Queries When Combobox Changed

I have a userform with one textbox and one combobox in EXCEL.

This userform is connected to a small data base (one table with 2 columns).

Combobox is populated with the values from the first column of databasqe table.

I like when the combobox is changing the textbox to be automatic populated with the corespondent value from the second column.

I have the following code but it is not working:

Code:

Sub PopulateTB()
Dim rs As Recordset
Dim db As database
Dim SQL As String
Set db = OpenDatabase(ThisWorkbook.Path & "materiale.mdb")
SQL = "SELECT values_col2 FROM table_db WHERE values_col1 = " & UserForm1.ComboBox1.Value & ";"
Set rs = db.OpenRecordset(sql)

[code]....