现在有个SQL查询问题！

数据库11.mdb中有表yellow，字段如下：yellow,red,blue,green!索引为：yellow!

现在需要跟据“input textbox”里的内容，查询相应的red ,blue, green 到

red textbox,text1 textbox,text2 textbox!!

拜托各位了！希望能予以解决！

怎么没人能帮我吗？

提供一个核心语句
Private Sub input1_KeyDown(KeyCode As Integer, Shift As Integer)
...........
rsstr = "select" & "'" & input1.Text & "'" & "from psxt"
..........
End Sub
注：input不能作为textbox的名字，我将其改为input1

Private Sub input1_KeyDown(KeyCode As Integer, Shift As Integer)
if keycode=vbkeyreturn then
...........
rsstr = "select" & "'" & input1.Text & "'" & "from psxt"
..........
end if
End Sub