E
elicooper
I'm trying to set a listbox's Control Source to an Opened Record Set,
however, I cannot get it to work. Is this possible? Please see the
below code. Thanks!
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim rst As DAO.Recordset
Set db = CurrentDb
Set qdf = db.QueryDefs("qryClassListByDate")
qdf.Parameters(0) = _
DateSerial(Year(Date), Month(Date), 1)
qdf.Parameters(1) = _
DateSerial(Year(Date), 1 + Month(Date), 0)
Set rst = qdf.OpenRecordset
Me.lstCourses.RowSource = rst
however, I cannot get it to work. Is this possible? Please see the
below code. Thanks!
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim rst As DAO.Recordset
Set db = CurrentDb
Set qdf = db.QueryDefs("qryClassListByDate")
qdf.Parameters(0) = _
DateSerial(Year(Date), Month(Date), 1)
qdf.Parameters(1) = _
DateSerial(Year(Date), 1 + Month(Date), 0)
Set rst = qdf.OpenRecordset
Me.lstCourses.RowSource = rst