If you convert your MS Access backend to SQL Server backend you will lose the datagrid/datasheet filter dropdown list.
To get it back you need to go to File-Options-Current Database. Under the Filter Look Up you will see ODBC Fields. Just check that box, close and open the app. Then it's available.
One point to watch for is that if the data is read-only, it will not filter.