Re: Show last 'X' records in a subform

Steve S <SteveS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Have a form that the user uses to input data to create new records. these
records are displayed in a subform just below the data entry fields. I now
have the subform set to display all records in reverse order so the user can
see the latest added at the top fo the subform(decending order). this is
confusing for some users ( if not all). they want to see the latest record
entered at the bottom of the subform (ascending order) which means they have
to hit the scroll bar to get to the bottom of the list. Pain in the...

Is there a way to set the subform properties to show the last X records in
ascending order instead of the first x records???

No, but you can use the subforms recordsetclone, the recordset
movelast, moveprevious and bookmark to set the subform to the desired
position.

I've been meaning to do a web page on this topic and hopefully will do
it in the next day or so. So check back here.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Sorting records within a subform based on two control fields
    ... I have an issue with sorting records within a subform based on two control ... I want those records to be sorted in the Subform ... in ascending order to read for example according to the following two fields: ... I wrote the following SQL code in a Public Function within the class module ...
    (microsoft.public.access.forms)
  • Re: Show last X records in a subform
    ... records are displayed in a subform just below the data entry fields. ... have the subform set to display all records in reverse order so the user can ... entered at the bottom of the subform (ascending order) which means they have ...
    (microsoft.public.access.formscoding)
  • Retaining Changes made in Subforms Pt 2
    ... In an earlier post I figured out how to permanently sort my date column ... my subform was pointed to a subform in the Forms Window ... subform to the query, so that I can permanently sort my "Sign-Out Date" ... field in ascending order, I couldn't retain the validation rule. ...
    (microsoft.public.access.gettingstarted)
  • Retaining Changes made in Subforms
    ... In an earlier post I figured out how to permanently sort my date column ... my subform was pointed to a subform in the Forms Window ... subform to the query, so that I can permanently sort my "Sign-Out Date" ... field in ascending order, I couldn't retain the validation rule. ...
    (microsoft.public.access.gettingstarted)
  • Retaining Changes made in Subforms
    ... In an earlier post I figured out how to permanently sort my date column ... my subform was pointed to a subform in the Forms Window ... subform to the query, so that I can permanently sort my "Sign-Out Date" ... field in ascending order, I couldn't retain the validation rule. ...
    (microsoft.public.access.gettingstarted)