Ask Your Question

Libreoffice Base - Save Records in Forms SubForms SubSubForms

asked 2016-05-28 19:58:09 +0100

hmadhi gravatar image

Is there a way of saving data records in a Form/SubForm/SubSubForm with a single click (except the obvious "Save" Button)? I know how to add a button action to save a record on a Form. However in some cases after entering data into a Form/SubForm there should be possibility of saving data with having to save data for each form separately.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-05-29 02:13:36 +0100

Ratslinger gravatar image

Each form, subform etc is connected to it's own data access - usually a table. Tables are independent of each other so adding records in one table doesn't trigger an add in another. Even using macros and other means, each table is independent and records added one at a time. Based upon your question, you can create a macro to save all three tables with one button but code will be necessary for each table involved.

edit flag offensive delete link more


k thanks for the reply. For the sake of completeness and for the benefit of others as well can you help with a macro to do this. Alternatively can you provide a link?

hmadhi gravatar imagehmadhi ( 2016-05-29 22:27:00 +0100 )edit

Since each circumstance is different, there is no one maco to cover all. It is totally dependent upon what is trying to be accomplished. Personally, I don't see any use for this. There are too many variables to account for. All my discoveries have come through meticulous examination using Xray and Mri.

Ratslinger gravatar imageRatslinger ( 2016-05-30 02:09:00 +0100 )edit

I agree. Its easier to hit Ctrl-S...

hmadhi gravatar imagehmadhi ( 2016-05-30 21:50:09 +0100 )edit

After editing a row in a subform, just click into a field on the main form or on a different subform. LibreOffice will save the new/edited data.

TonyG gravatar imageTonyG ( 2020-11-08 19:19:04 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-28 19:58:09 +0100

Seen: 732 times

Last updated: May 29 '16