Go to next record, defined by date

[Evergreenh]

Hi there

Having a little problem and wondering if someone can help me. Im on FM10 BTW.

I have an event database with fields EventName and DateOfEvent.

I've set a Script Trigger so that whenever anyone does a find on an EventName the events found are put in date order. But it would be really useful if it automatically went to the next event after todays date (they happen once a month, so usually within a 31 day period). I have a TodaysDate field as well.

Can anyone help me with this? I would really appreciate some assistance.

Sorry I just realised I called this topic 'Go to next record...' but it should say 'Go to record...'

[Matthew F]

If your list is not extremely long, then I think you could add some extra steps to your script. Go to the first record (sorted by date) and then do a loop that simply goes to the next record until the event date > today's date, or until you are at the end of your list.

[Evergreenh]

Works like a dream! Thank you so much for answering this for me. Very appreciated!

Kelly

XXX