标题: sql怎么用变量做查询条件 [打印本页] 作者: lovinana 时间: 2009-9-29 22:59 标题: sql怎么用变量做查询条件 Private Sub 材料名称_AfterUpdate()
Dim STemp As String
Dim cailiaomingcheng As String
cailiaomingcheng = Me![材料名称]
STemp = "SELECT * FROM 入库资料表 WHERE 材料名称 = " & cailiaomingcheng & " ORDER BY 入库日期 DESC"
DoCmd.RunSQL STemp
End Sub