With go to record, you'd have to go to the first record, then loop through the records with go to record [next] until you reach the desired record.
Here's a sneakier way to do it without all the looping records:
If you haven't already done so, define a auto-entered serial number field to uniquely identify each record. Define a new global field, gSelectedRecord that is also of type number.
Define a self join relationship like this:
YourTable::gSelectedRecord = YourTable2::SerialNumberField
Now let's perform two finds. First a "tight" find that only finds records of the current month that also meet your search criteria, then a "loose" find that finds all the records you want to display.
In your script perform the "tight" find. Then your script does this:
Sort Records [restore ; no dialog]
Go To Record/Request/Page [First]
Set Field [YourTable::gSelectedRecord ; YourTable::SerialNumberField]
Now perform the find that finds all the records you want to see on the layout. Then do this step:
Go To Related Record [ From table: YourTable2; Current Layout ]//do not select "show only related records"
This makes the first record found in your first find the current record.
Works like a charm - Thanks.
I've also adapted it elsewhere, using a calculation (rather than a global) as the match field to save time searching!