How to filter a CurrentDb.OpenRecordset?
Posted on 2004-11-16
The filter that I am using, see below, has no affect. That is, the result is the same with or without the filter statements. In the example, below, I'm trying to gather all records whose CustIDs are 707. (in the final code, 707 would be a variable, but I'm now using a constant for testing)
With CurrentDb.OpenRecordset("Tabletbl1", dbOpenDynaset)
.Filter = "[CustIds]= 707"
rsFiltered = OpenRecordset
Again, works fine. But, is ignoring the filter. What am I doing wrong?