如何在Dlookup函数中调用临时表rst

kingorwell　发表于：2016-04-22 15:36:55 　

我想通过Dlookup获取窗体中当前“员工编号”的员工岗位，但是VBA说不认识“rst”的临时表，该如何在函数中引用rst？

Dim rst As ADODB.Recordset
     Set rst = New ADODB.Recordset
With rst
     .ActiveConnection = CurrentProject.Connection
     .CursorType = adOpenKeyset
     .LockType = adLockOptimistic
     .Open "select * from 员工岗位历史 where 员工编号='" & Me.[员工编号] & "'order by [序号] ASC" '
     Me.岗位 = DLookup("工段","rst" , "[员工编号]= '" & Me![员工编号] & "'")

Top

煮江品茶发表于：2016-04-22 15:46:28

纯粹脱裤子放屁。

Me.岗位 = DLookup("工段","员工岗位历史" , "[员工编号]= '" & Me![员工编号] & "'")

Top

kingorwell 发表于：2016-04-22 15:58:12

但是DLookup("工段","员工岗位历史" , "[员工编号]= '" & Me![员工编号] & "'") 中不能设定记录先后顺序吧？我需要加入order by [序号] ASC

Top

总记录：2篇页次：1/1 9 1 :

Access交流中心

如何在Dlookup函数中调用临时表rst