jemartalaban_1 0 Light Poster

hi , can u help me ... my problem is the recordset must be based on the text in the textbox like that, but its not working.

conp.Open ("Provider=MSDASQL.1;Persist Security Info=False;Data Source=PAYMENTS;Initial Catalog=payments")
rsp.Open ("select * from &Text12.text& where Term='" & Text10.Text & "'"), conp