Simple form display question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form formatted as continuous display in which I want the end of the
data to be displayed by default instead of the beginning of the data. I
don't want the order to be reversed, I simply want the last x records to be
displayed when the form is invoked instead of the first x records. In other
words, I want to see the most recent data displayed when the form is opened
but have the ability to scroll back to previous data.

There's must be an easy way to do this, I just don't see it.

Will
 
On the On Open property of your form put the following:

DoCmd.GoToRecord , , acLast


Hope this helps.
 
:
Jackie,
Thanks. that and
DoCmd.GoToRecord , , acPrevious,15
now gives me the last 16 records in the form. Just what i wanted!

Will
 
Back
Top