Question

请问下access中怎么将SQL取得的值放入一个文本框中并同步显示出来

Answer 1

set rs=conn.execute("select * from Human where [工号]='"&text1.text&"'")
if rs.eof then
msgbox("无记录")
else
text2.text = rs("姓名")
end if