Apache OpenOffice Community Forum

Posted: **Tue Jan 28, 2020 1:07 pm**

Hi,

I have a simple macro assigned to a push button to change allowupdates to "true", but for it to work it needs to reload the form. When the form is reloaded it goes back to the first record but I need it to stay on the current record. Is there a way of doing this?

Posted: **Tue Jan 28, 2020 7:29 pm**

Try this:

Code: Select all

Sub Reload_Form_keep_current_Row
    oForm = ThisComponent.DrawPage.Forms.getbyName("MainForm")
    nRow = oForm.Row
    oForm.reload 'reload form
    oForm.Absolute(nRow) 'set the cursor back to previous current row
End Sub

R

Posted: **Wed Jan 29, 2020 11:44 am**

Perfect, thank you!

Apache OpenOffice Community Forum

[SOLVED] Reload form but stay on current record

[SOLVED] Reload form but stay on current record

Re: Reload form but stay on current record

Re: Reload form but stay on current record