Code to go to the last register inserted

DarkHorse

Hello, I'd like to know which code I have to insert in a Form so that always go to the last register inserted each time that it runs.
Thanks.

McClane

If your primary Key(s) are set atomatically, set Ranges on it and find('+'). If you set the key(s) manually, you could add a field with a timestamp and find the newest entry searching over it.

DarkHorse

Thanks for your reply. The problem it's that the report ejects from a codeunit, it make's a process and when it end's I put form1.RUN; and it goes to the form, but it's positioned at the beggining but I want that it positioned at end of the form, then I have to put it in code. How can I do it?.
Thanks.

kine

1) There is property for this on the form - you can select if you want to poition the cursor to first,last, previous record - but it is form wide (e.g. dangerous if set on Lookup form).

2) When running the form, you can pass the record, and if you do FINDLAST (or FIND('+')) on the recod, the cursor will be there (if not overriden by the property from point 1)

DarkHorse

Thanks both for your help. I'll try it.
Thank you very much.