I have an access form that when I open it with all records it opens fine, however when i open it with a filter, requesting just one record it takes some significant time to open, Wondering what can i do to improve it?
The undderlined source is a linked sql table.
I did already the following
1- created an index on the field used to filter.
2- tried modified the record source of the form it should only contain the desired record.
So far none of these helped..
the table which this form is bound to contains about 35k records.