Is there a faster way to go to the next record?

[georget]

I'm trying to increase speed. I did all the common tasks, such as changing field types and compress and repair.

1) The database has a Table with 7000 records. When I open a form, I could press "next record" and go to the next record in less than a second.

2) I added 80,000 records. Now when I press next record it takes almost 4 seconds.

a) the form opens from a Query

Even when I filter the Query that displays less than 2000 records in the form, it still takes more than 4 seconds to go to each record. (it's like it's searching through the 87,000 records)

What can I do to increase the speed when I have filtered results it doesn't respond as if it's searching the 87,000 records?


THANKS!

 

[georget]

I figured it out.

1) I changed my orginal table name from "data" to "all records"
2) I created a "Make-Table" Query that filters to the table "data"

performance problem solved. hope this helps others.