See if this helps:

strSQL1 = "SELECT value_f.V_NAME "
strSQL1 = strSQL1 & "FROM value_f, db_field WHERE db_field.ID= '" & value_f.VF_CODE & '"
strSQL1 = strSQL1 & " and db_field.FIELD_N ='" & cboCity.BoundText & "'"