Moving to Last record and display

[Samantha]

Hi All,

I'm using the form to both display data and data entry. When displaying
data, I have swich off the AllowAddition property of the form, and turning it
back on for data entry. The detailed records are displayed on the Details
section of the form.
The form is set to have record selectors at the bottom. I have trained the
end users to look at the record selectors at the bottom to understand how
many total detailed records are associated with each header ID. The total
records are displayed next to the record selectors.
The problm is that for whatever reason, it is very slow when trying to
display mulitiple detailed records. Is there a way to manually "move to the
last record" so that we bottom left hand corner of the total records show up
faster? Unless I'm doing something totally ineffective to cause this slow
down in record retreival?
Thanks so much in advance.

 

[Jeanette Cunningham]

Samantha,
this is the default access behavior when the form has a large number of
records.
The form loads quicker by loading with only a few records, the rest of the
records load in a few seconds.