请问高手:如下代码错在哪里?如何从已有记录集中生成新的子记录集?Function FilterField(rstTemp As Recordset, strField As String, strFilter As String) As Recordset
rstTemp.Filter = strField & " = '" & strFilter & "'"
Set FilterField = rstTemp.OpenRecordsetEnd Function执行 Set rst = FilterField(rs, "rs.Fields(7)", KeyStr) 时,提示类型不匹配。已知:rs为已存在记录集,keystr为 关键字(字符串) ,用dao 连接数据库已成功,rs已经取得。目的是:想从rs中抽取字段xxx中的值(字符型)=keystr的记录,形成新的记录集。请高手指教!谢谢!◎-◎
rstTemp.Filter = strField & " = '" & strFilter & "'"
Set FilterField = rstTemp.OpenRecordsetEnd Function执行 Set rst = FilterField(rs, "rs.Fields(7)", KeyStr) 时,提示类型不匹配。已知:rs为已存在记录集,keystr为 关键字(字符串) ,用dao 连接数据库已成功,rs已经取得。目的是:想从rs中抽取字段xxx中的值(字符型)=keystr的记录,形成新的记录集。请高手指教!谢谢!◎-◎
rstTemp.Filter = strField & " = '" & strFilter & "'"
Set FilterField = rstTemp
End Function
ss=rs.fields(7).name
Set rst = FilterField(rs, ss , KeyStr)