Access frontend - SQL Server backend - Ctrl-f (find option not working)

[Derevon]

Hi everyone,

So I have this tracker type database with an SQL server backend, and I just noticed that using Ctrl-f to find some record or using DoCmd.FindRecord doesn't seem to work unless the records are already loaded. It simply loads and loads indefinitely or until pressing Ctrl + Break.

I would want the users to be able to search for specific records without having to use a filter to find what they need.

Does anyone know of a solution to do this?

Thank you

 

[cheekybuddha]

Create a dedicated search textbox, or search form that fires off a query against the SQLServer.

Bind it to Ctrl+F, perhaps using an AutoKeys macro.

ps. what's wrong with a filter?