Solved Record is deleted (multi user database) (1 Viewer)

[CJ_London]

CJ, do you know for a fact that the Filter and Where both bring in the entire recordset?

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.

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