I have a continual form which displays many records at once. Each record has a date field in it and the records are ordered by date. What I need to be able to do is loop down to the first record that contains the current date. But I need to also be able to scroll back up or down if necessary so I can see records with an earlier or later date.
I need something like this but are not sure of the correct syntax:
DISPLAY RECORDS IN ORDER OF DATE
LOOP UNTIL THE DISPLAYED RECORDS DATE = CURRENT DATE