Get value from next record displayed on current record

[JHDavis]

How do I display the value of a field from the next record in an unbound text box on the first record.

On the report, I would like the to show the current Speaker as well as the next speaker based on the field (Speaker).

So I want both a textbox showing the current speaker (simple) and textbox showing the next speaker to appear on a single page of the report.

Any ideas?

 

[grnzbra]

if you have your table of speakers with a numbered field increasing by 1 in the order they appear, you could possibly create a function that would lookup the speaker name based on the current speaker's number plus 1. then set the NextSpeaker field equal to the function.