record position in block 1

[carolinaof]

Is there any way I can scroll to the selected record in a block in forms, so that it will appear in the first position? go_record select the record, but does not place it on the top of the block.

Thanks in advance for help.

 

[lewisp]

Use this code:

go_record(<record_number> + to_number(get_block_property('<block>',records_displayed)) - 1);
Go_Record(<record_number>);

 

[carolinaof]

Thank you for such a simple solution. It was very helpful.