Dim Quey As QueryDef Dim db As Database Dim rs As Recordset
Set db = OpenDatabase("DB.mdb") Set Quey = db.CreateQueryDef("") With Quey .SQL = "SELECT * FROM 表名" & "WHERE 日期= '" & Combo1.Text & Combo2.Text & Combo3.Text & "'" Set rs = .OpenRecordset() End With
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase("DB.mdb")
Set Quey = db.CreateQueryDef("")
With Quey
.SQL = "SELECT * FROM 表名" & "WHERE 日期= '" & Combo1.Text & Combo2.Text & Combo3.Text & "'"
Set rs = .OpenRecordset()
End With