I wonder if there is a way to get my text list to display faster. I have a database with 1700 records. I have a form with a text list to display summary records only. First I group up and then total several fields. That takes just under 2 seconds after I select the menu item. But opening the form with the text list takes another 8 seconds. There are seven columns and a typical column in the text list formula looks like
(Matter number is a field that groupup was applied to.) I have 5 aggregate functions, but taking them out makes no perceptible difference. Database Navigator is unchecked.
If it takes 10 seconds, okay, but if I can speed it up, I would like to. Any suggestions on strategies that I might try?