- Local time
- Today, 06:44
- Joined
- Feb 19, 2013
- Messages
- 16,610
for a fact, no - but when unfiltering a very large recordset where the WHERE parameter has been utilised it takes no time at all which implies the whole recordset has been loaded. I believe the access feature which allows the first 'screen' of records to be displayed whilst the rest of the recordset to be loaded is still working - but prioritises the selected criteria to display first.CJ, do you know for a fact that the Filter and Where both bring in the entire recordset?
I hadn't picked up on a sql server backend being in use. The filter argument is not a filter, it is an alternative query
A string expression that's the valid name of a query in the current database |