首先设置datalist的listfield 为name,boundcolumn 为password form_load() dim rs as adodb.recordset set rs=new adodb.recordset rs.open "select name,password from login",conn,3,3 set datalist.rowsource=rs end subdatalist_click() me.datacombo.text=datalist.boundtext end sub
我有一张login表,包含name和password两列,我要实现在datacombo里显示name,当我选定一个name时,在datalist里显示他对应的password,怎么做?
form_load()
dim rs as adodb.recordset
set rs=new adodb.recordset
rs.open "select name,password from login",conn,3,3
set datalist.rowsource=rs
end subdatalist_click()
me.datacombo.text=datalist.boundtext
end sub