Listbox OrderBy

[ram_rtg]

I run a front end database and I have found that it is a bit slow when it reorders the fields. there's a bout a 5 seconds delay.

It there a way to get the data contained in the listbox to sort the fields by accessing an intermediate location (for example from Ram memory) instead of re-running the SELECT statement each time?

Thanks in advance.