Scrolling subforms

[Phil]

I have a subfom sized to show up to 16 records i.e. about 4" high and each
record is about 1/4" high The subform itself can contain anything from no
records to many hundreds. I want to go to a new record, bur see as many of
the preeceeding records as possible, so the new record needs to be near the
bottom of the subform. Using Access 2010, what is the easiest way please?
Phil

[Ron Paii]

"Phil" <ph...@stantonfamily.co.uk> wrote in message
news:jq51f1$97e$1...@speranza.aioe.org...

Access has no record number. You will need to sort the subform on a field or
fields that will put the records in the order you need.

[Patrick Finucane]

If A2010, a split form might work nice.

[Phil]

Thanks Ron
The records are already sorted in date order. I suppose I want to see the
last 15 records (assuming that there are at least 15 records), then move to a
new record. If there are less than 15 records say 7 records, the new record
will appear in the middle of the subform so no problem.

Phil

[Phil]

Thanks but not what I want

Phil

[Phil]

Solved it

The subform is on a Tab control.
The OnCurrent of the main form or on changing tabs I call this StayOnTab
routine (abbreviated)

Sub StayOnTab()

Dim i As Integer
On Error GoTo StayOntab_Err

If TabCtl118 = 1 Then ' Dividends
DoCmd.GoToControl "subDividends"
DoCmd.GoToRecord , , acLast
For i = 1 To 15
DoCmd.GoToRecord , , acPrevious
Next i
DoCmd.GoToRecord , , acNewRec
End If

Exit Sub

StayOntab_Err:
If Err = 2105 Then ' You can't go to the specified record
Resume Next
Else
MsgBox "Error" & Err & " " & Err.Description
End If

End Sub

Thanks anyway

Phil