Sort Button

[dkao99]

I encounter a problem with refreshing when I click the sort button icon on a form that has 15,500 records with 25 columns initially. There is no problem scroll/page down/up on initial form but after I select a column and hit the sort button icon, I can see the screen refreshing row after row slowly(same thing happen if I scroll/page down/up). I am trying to catch the column name after the sort button icon is click so I can issue the query directly. Does anyone know how to solve this problem?

[NeoPa]

Is the Sort Button something you've implemented yourself or a built-in facility?
Which version of Access are you using?

[dkao99]

It is the build-in on Menu Bar. I am using Access 2003 VBA.

[NeoPa]

In that case I'm not sure that I can be much help.
With a fairly large table such as yours though, the response times will depend very heavily on whether or not the selected column (field) is included in an index or not. The original order will certainly be (unless you've specified a sort order explicitly yourself in the design), so will be much more responsive than the same data sorted by a non-indexed field.

[dkao99]

I choose a column that I knew is indexed on SQL, the result is the same. Can you have index on Recordset? I know when the sort button is click, the column name is put on the form property "Order By". Can I catch that on the event "Before Render" and reissue the query? The last thing that I think about is having the cobmo box with all the columns that can be sorted. And let the user know only to use it when there are a large records.

[NeoPa]

I'm sorry. If you're already using indexed fields then I don't know why it would slow down :(
The Form property Order By is quite likely to be updated when you sort. That makes sense, but it doesn't help us any that I can see I'm afraid.