|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2005, 03:42 AM
|
|||
|
|||
navigate records slow
I have an app to use dropdown box to filter records from SQL server table.
I found that when I navigate (scroll) the records is very slow. Because the records are already filtered, is it possible the index issue? Any information is great appreciated, Souris, 
|
|
#2
May 12th, 2005, 10:36 AM
|
|||
|
|||
|
Usually the slow scroll down happen when you have a calculated field in the
form, so when you scroll down to the next record it run the calculated field. Could be that one of the field has a dlookup, or a function call. "souris" wrote: I have an app to use dropdown box to filter records from SQL server table. I found that when I navigate (scroll) the records is very slow. Because the records are already filtered, is it possible the index issue? Any information is great appreciated, Souris,
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking multiple records | David Price | General Discussion | 1 | April 15th, 2005 11:28 PM |
| Find all records in a field from a table that contains a key word. | Qaspec | Running & Setting Up Queries | 1 | April 12th, 2005 05:31 AM |
| Information from Table to Report | Dahlman | General Discussion | 6 | April 11th, 2005 09:57 PM |
| New records can't be seen | rleblanc | Using Forms | 6 | August 14th, 2004 02:43 PM |
| Copying new records | John | General Discussion | 0 | June 25th, 2004 04:02 PM |
Linear Mode
