You need to modify the recordset to use a joined query to return the data from both tables. With out knowing the structure of both tables I cannot give the exact syntax to use, have a look at the following on the w3schools site for information on join queries:
sql_join_inner.asp
NOTE: bgw1999373018, your issue is a bit different since you are trying to get the labels from a select list. Your solution will not be applicable here.