Is Base Form Navigation working as designed?

[MikeTheBoat]

If you navigate to the LAST record in a data set using the navigation controls in a form, both the NEXT RECORD button and the LAST RECORD button remain active. Pressing either then creates a new record, which is not ‘correct’ behaviour. If you navigate to the FIRST record, the PREVIOUS button is greyed out - which is what I would expect. This behaviour occurs with both the standard form navigation and the separate form navigator control. If this is working as designed, what is the rationale - it seems to encourage inadvertent creation of records when this was not the intention.

The behaviour seems consistent across all recent releases, up to and including 6.2. Running on Linux Mint 19.1

[Ratslinger]

Hello,

Have not seen this in any version thus far. Here is LO v6.2.1.2 (TDF version) on Mint 19.3 with all three types of navigators:

None show the ‘Last Record’ button active when on the last record.

You may want to try running in safe mode to see if you have a LibreOffice user profile problem.

I personally don’t agree with “…it seems to encourage inadvertent creation of records…”.

[MikeTheBoat]

My fault for imprecision, but in your screen dump the NEXT record button is still active, even when on the last record - surely this is inconsistent with the LAST RECORD button being deactivated

[Ratslinger]

This probably dates back into OpenOffice and maybe even to StarOffice days.

Do see other places, MySQL Workbench for one, where you need to specifically press a New Record button and not simply Next Record. You can request a change at Bugzilla.