Top X

Thanks for the repllies, however they don't quite cover what I am needing.  In my contiuous form, I want all the records available to view by scrolling, but when the form opens I want the bottom "x" numbers of records to be visible in the form like in a quicken file.  I can scroll back up to see any previous record I want.  But always want the newist record to be on the bottom of the list.

Just add an ORDER BY to get them however you wish

Thanks again for the tips.  I found what I needed by a google search.  Thought I would share for future use
Here is the VBA code I found to be placed in form load:  
    Dim rst As Recordset
    Set rst = Me.RecordsetClone
  
    If rst.RecordCount <> 0 Then
        rst.MoveLast
        rst.Move -20
        Me.Bookmark = rst.Bookmark
    Set rst = Nothing
    End If
Works perfectly for what I want,

Can you be sure there'll always be at least 20 records?

I can adjust the number to any I want, but right now out of 688 records, this code fills my continuous form with the bottom 20 records, but I can scroll up to see any of the other 688 records.  I also have a search file on the form that filters records to what I need.