[SOLVED] Reload form but stay on current record

[MHCom]

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?

[F3K Total]

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

[MHCom]

Perfect, thank you!