Recognizing last record and existing to next layout

[TaiChi56]

Go to Record/Request/Page (first)
Loop
 #do something here with the current record
 Go to Record/Request/Page [Next; Exit after last]
End Loop

 

I found this code but cannot seem to figure out how to use it for my purposes. What I have is a quiz with about 20 questions. I have a button called "Next" to go to the next question. On the last page I want that button to exit the quiz and go to another layout. But if I put go to next layout, it is on every button. I hope this makes sense.

 

So the next button needs to go to the next record until the last record and then exit to another layout. How do I keep it from being global where it affects every button on the layout? Thank you.

[Raybaudi]

The script could look like:

 

If [ Get ( RecordNumber ) = Get ( FoundCount ) ]

Go To Layout [ "YourOtherLayout" ]

Else

Go To Record [ next ]

End If

[TaiChi56]

Excellent, worked perfectly. By the way I lived in Gaeta for 5 years in the early 80's. Loved it. Take care.