disp[layinf records on a form

[Guest]

is it possible to display the nth record and the nth+1 record on the same form
then when u press 'say' next reocrd u skip 2 records
and display the nth+2 and the n+3 recordes on the same output

etc
ie, i want to display to sets of records at a time for the nth and nth+1
records

 

[Michel Walsh]

Hi,

Possible solution:
Have a form that displays just one record in the detail, and add control
to display what may come from one record in the form footer.

In the onCurrentEvent, "push" the values of the next record in the
controls you added in the form footer.

You can move to the next record with something like:

' in the OnCurrentEvent Handler subroutine
Me.RecordsetClone.Bookmark= Me.Bookmark ' synch the position of the
clone to the position form the form
Me.RecordsetClone.MoveNext
Me.FooterControl1 = Me.RecordsetClone.Fields("FirstField")
...
Me.FooterControlN = Me.RecordsetClone.Fields("NthField")



Hoping it may help,
Vanderghast, Access MVP