Scroll bars

[monad]

I'm trying to auto scroll the Detail Section where the user will able to see the last record on my continuous form.

Can anyone tell me how to do this?

My sincere thanks!

 

[MarkK]

Cheesey, but this'll work for later version of Access...

Private Sub ShowLast(count as Integer)
  Dim i As Integer

[COLOR=Green]  'reference the recordset object[/COLOR]
  With Me.Recordset
[COLOR=Green]    'move to the last record[/COLOR]
    .Movelast
[COLOR=Green]    'move up a few records[/COLOR]
    For i = 1 to count
      .MovePrevious
    Next i
[COLOR=Green]    'and move to the last one again[/COLOR]
    .Movelast
  End With

End Sub

 

[monad]

Thanks

Thank you lagbolt! I'll give it a try.

 

[monad]

lagbolt

That did it lagbolt! Thanks again!