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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hello happy new year to all, Text box input for year of purchase 0
Access Form Refresh 1
Why is my "continuous form" subform not working right? 10
Using DSUM to get running total on a filtered form 0
Displaying Records In A Continuous Form 3
Access Access Report Works on One Machine but not Another 3
Display all records on form 8
Opening form unexpectedly closes other form 0

Back
Top