Id like to filter thisr ecordset with a value from a form...however...the filter does not seem to do anythong...please advise.
PHP:
Function getCalendarData() As Boolean
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("qry_employeeAttendance", dbOpenDynaset)
rs.Filter = "EmployeeID = [Forms]![FRM_Main]![FRM_Welcome]![user]"
You can use the Filter property to restrict the records returned from an existing object when a new Recordset object is opened based on an existing Recordset object.
Just to clarify your intention. Must you open an unfiltered recordset and then subsequently apply a filter to it? Or would opening a filtered recordset to begin with, as has already been suggested, be sufficient?
Most developers would use Paul's suggest but you can assign a filtered recordset to a new recordset (or itself). Something like
Code:
Dim rst As DAO.Recordset
Dim db As DAO.Database
Set db = CurrentDb
Set rst = db.OpenRecordset("SELECT * FROM someTable")
rst.Filter="ID<=200"
set rst=rst.openrecordset
However there is no going back, once filtered, the records filtered out are lost - unless you assign to a difference recordset
Code:
Dim rst As DAO.Recordset
Dim db As DAO.Database
Dim Frst as DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("SELECT * FROM someTable")
rst.Filter="ID<=200"
set Frst=rst.openrecordset
then you can still go back to your unfiltered rst recordset. However any changes you made in Frst will not be reflected in rst.
I guess it can have it's uses but good practice is to bring the minimum number of records through in the first place.
