We have an application where users use an Access form to return a filtered recordset. The backend database can be either SQL or Oracle. In Access 2007 we have experienced an intermittent issue where the original filter is lost when using either the drop-down sorting from the datasheet headers or our right click menu that uses Access built-in sorting. 100% of the records are then returned and the filtered icon that was displayed is gone. This presents a large issue as some of our databases are very large. I have not been able to replicate at will or determine what causes the filter loss. Has anyone else experienced this or have any ideas what could cause this? It does not occur in previous versions of Access.