Go to last record used after restart of form

[nebergall]

I have searched for help with this and found everything other.
Specifically, I need to save the record number I am on when I quit the form or Libreoffice.
Then when I launch the form I’d like to return to the record I saved. I assume I need a macro and a table to save the last record (row) number. I could live with a button to do this after launching the new form as well, but prefer the former (going to the “old” record upon launch).
Thanks

[Wanderer]

@nebergall

assume I need a macro

I guess: 2 macros and a place to store your row-number(s).

As my filter tables recover after new start I suggest to use the same system to store your row-id. Then you need one macro to save this on closure of form/file/base (to be decided) and a second to jump to this record at startup/open form etc.

[nebergall]

Wanderer,
That makes sense to use two macros.
I am a newbee with macros and LibreBase. Do you have examples?
Thanks

[Wanderer]

Google has…

How can I convince Base to go to a specific record on opening a form?

There does not appear to be a simple answer to this. All I want to do is Open a Form and go to a specific record, rather than Opening the form and then having to scroll through the records to the specific one. Is there an EASY way using macros. I was able to do it back in M$ days. Background My Philately Database is normalised and consists of a Country Table linked to Stamps linked to MyCollection. At this stage, all I want to do is to return to the last selected Country whenever I open a form…

Can I move specific record in a form in Libreoffice Base via Macro coding?

Hi, nice to meet you, everyone. I have a question about moving records in Libreoffice Base Form. I understand moving the first or last record. eg. oForm.last() Then How can I move to a specific record by specific field (eg. ID number) I assume It will be oForm.Columns.getbyname(“ID”).set = ID value What I want. oForm.move or oForm.Columns.getbyname(“ID”).setvalue(D value What I want) then succinctly moving to that place What I Want. How can I moving to the place what I want to move vi…