I was wondering how to go about showing a record within a recordset and somewhere else on the page shows the next record in line. Is this possible? I would also like it to update when someone clicks next which in turn updates the next record data.
I know how to do ordinary recordsets but can't think how to show the next record somewhere else.
Any suggestions how to do this would be a great help