下面是playpersonquestioniteminfo方法 public function displaypersonquestioniteminfo(byval pid as string) dim strsql as string frmindex.lstquestionitem.clear on error goto msgerr: strsql = "select * from 表信息 where 表id in (select 表id from 结果 where 个人编号= ' " & pid & " ' group by 表id ) order by 表中文名 " if mdlconnectiondb.EXECutestr(strsql) then while not g_tblrs.eof frmindex.lstquestionitem.additem (g_tblrs.fields( "表中文名 ") + "( " + g_tblrs.fields( "表英文名 ") + ") ") frmindex.lstquestionitem.itemdata(frmindex.lstquestionitem.newindex) = g_tblrs.fields( "表id ") g_tblrs.movenext wend end if if frmindex.lstquestionitem.listcount > 0 then frmindex.lstquestionitem.listindex = 0 end if exit function msgerr: msgbox "查询失败,纪录不存在! " end function