Filter to last 6 records

paul_newns

Hi,

I'm trying to use onnextrecord to filter the records displayed to the last 6 occuring, but i am having issues with the trigger. One of which is that it keeps asking me if want to rename the record. Can some give me a breakdown of the best way to write this.

Cheers in advance.

einsTeIn.NET

Not sure where you are and what you want to achieve, but OnNextRecord in a Form/Page is used to do something if some next record functionality (e.g. Next Arrow in the menu bar) was used. And you have to be very careful with it because if you put code in here then the standard behaviour will be replaced.

Also have a look at NEXT function. Parameter Steps could be used to get the 6th last record, e.g.

FINDLAST;
NEXT(-6);