Hi all,
A little background: my database has a main table of projects with about 275 records (with about 40 fields per record), and each record is linked with 0 to 10 additional issue records in another table (depending on the project).
I've got a form for entering and modifying the data (including a subform in continuous mode to work with the issue records).
If the form has no sorting or filtering applied, performance is acceptable when going between records, but if a sort (such as sorting projects by name or by project leader) or filter (such as excluding inactive projects) is applied, performance SEVERELY suffers (i.e. about 5 seconds or more to go to the next or previous record). This makes it very tedious to find the desired record, as you might imagine...
Are there any simple tricks that might improve this slowdown?
One idea I had is to create another form that has only a few key fields on it such as project leader and project name (most likely in a list box) and a checkbox or two for the common filters, and filter on this subform to display a list of projects, from which the user can select the project desired, which will then jump the main form (unfiltered and unsorted) to the right record. (though I'm not sure exactly how to make this jump happen).
Any help would be much appreciated.
Thanks!
asp
A little background: my database has a main table of projects with about 275 records (with about 40 fields per record), and each record is linked with 0 to 10 additional issue records in another table (depending on the project).
I've got a form for entering and modifying the data (including a subform in continuous mode to work with the issue records).
If the form has no sorting or filtering applied, performance is acceptable when going between records, but if a sort (such as sorting projects by name or by project leader) or filter (such as excluding inactive projects) is applied, performance SEVERELY suffers (i.e. about 5 seconds or more to go to the next or previous record). This makes it very tedious to find the desired record, as you might imagine...
Are there any simple tricks that might improve this slowdown?
One idea I had is to create another form that has only a few key fields on it such as project leader and project name (most likely in a list box) and a checkbox or two for the common filters, and filter on this subform to display a list of projects, from which the user can select the project desired, which will then jump the main form (unfiltered and unsorted) to the right record. (though I'm not sure exactly how to make this jump happen).
Any help would be much appreciated.
Thanks!
asp