Am 05.11.2014 um 02:51 schrieb Mark LaPierre:
It would be nice to post the solution here on the string that is
labelled "[Solved]" so that people searching for the solution can find
it. Maybe Peter should do that since he seems to have a better grip on
The clean solution without macros:
1) Open an embedded form document and save it as a regular Writer document.
2) Close the form and load the new document from the new location.
3) Turn on edit mode, get the form design toolbar and click its 5th
button for the form navigator.
4) Get the main form's properties dialog, second tab "Data".
5) Copy the "Source" string first.
6) Unlike the embedded form, this one has a "Data Source" property.
Choose the registered name of your data source or use the [...] button
to pick the database file. (registration has several advantages).
7) The "Source" property is wiped out when you change the data source
but you have it in the clipboard. Paste it back into the "Source" box.
8) Repeat 5) to 7) for all the forms and subforms on the same form document.
9) Save and close the form document and make the file read-only.
Now you can open the form document just like any other document without
loading the database document and you can add ordinary hyperlinks to
switch between form documents. Of course, you can use desktop hyperlinks
In rare cases you may use another option that is not availlable with
embedded forms: Subforms can be bound to data sources other than the
main form. For instance your subform may show all the database records
related to the main form's selected record that is stored in a spreadsheet.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy