default to show bottom of list, not top

  • Thread starter Thread starter CuriousMark
  • Start date Start date
C

CuriousMark

How do I code for the default display of a continuous form to show the bottom
of the list instead of the top? I am using the continuous form as a subform.
 
"Bottom" and "top" depend on your criteria ... and you haven't described
them.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
It shows the results of a query sorted by date, ascending, so the most recent
is at the bottom. I could sort in reverse order, but then the most recent
would be at the top, and I want the records listed with the most recent at
the bottom, and I want that part of the list shown by default. Thanks.
 
I guess I'm not following. If you sort it ascending, that isn't what you
want ... but if you sort it descending, that isn't what you want either?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I want the records listed with the most recent at the bottom
Your post is still confusing. Is not the 'most recent' the latest date?
Why can you not use the date sorted descending?

What do you have that distinguishes the'bottom' from the 'top'?

Post sample data in the manner you want it sorted and explain what within
the data is sorted.
 
I'll try....

I have a query that returns lots of records, about 3000, and I display that
list in a continuous form. The query sorts the records by date, ascending, so
that the oldest entry is at the top of the list, and the most recent is at
the bottom of the list. The form that displays the results is not nearly long
enough to show all the records, and the default is to show the top of the
list. I want it to show the bottom of the list without having to scroll down
when it opens, so that the most recent entries, which remain at the bottom of
the list, are shown by default.

If the entries are numbered from 1 to 3000, I want them to stay in order
from top to bottom, and to see 2990-3000 without having to scroll down.
 
When the results are shown in a list, the default view of the list is to show
the top of list: the vertical scroll is at the "top". If you want to view
records farther "down" the list, you have to move the vertical scroll to the
bottom of the list. I want to keep the sort order, with newer entries at the
bottom of the list, but I want the defaul view to show the bottom of the
list, not the top. Kind of like if this window default were to show the text
at the very end of the discussion when the window first opens, rather than
the text at the top.
 
If the entries are numbered from 1 to 3000, I want them to stay in order
from top to bottom, and to see 2990-3000 without having to scroll down.
Click to expand...

Put code in the subform's Open event:

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord, , acLast
End Sub

Look at the help for the Move command if you'ld like to move back ten records
or so.
 
Great. Perfect. Thanks very much. After sleeping on it I woke up this morning
planning to try exactly this.
 
Back
Top