What's happening?

' Replace "NombreDeTuFormulario" with the exact name of your form oFormulario = oDoc.FormDocuments.getByName("NombreDeTuFormulario")

Create a macro, assign it to the "Open Document" event, and watch your database become instantly more professional. Do you have a favorite LibreOffice Base trick? Let me know in the comments below. ¿Te gustaría un tutorial sobre cómo crear formularios con subformularios?

Sub AbrirFormularioYLimpiar Dim oFormulario As Object Dim oFrame As Object Dim oDoc As Object oDoc = ThisDatabaseDocument oFrame = oDoc.CurrentController.Frame

' Open the form oFormulario = oDoc.FormDocuments.getByName("Clientes") ' Change form name oFormulario.open(oFrame)

Sub AbrirFormulario ' This macro opens a specific form in LibreOffice Base Dim oFormulario As Object Dim oFrame As Object Dim oDoc As Object ' Get the current database document context oDoc = ThisDatabaseDocument oFrame = oDoc.CurrentController.Frame

If you’ve built a database in LibreOffice Base, you know that the default navigation can feel a bit clunky. You open the file, and you’re greeted by the main database window—tables, queries, forms, reports. It’s powerful, but not very "user-friendly," especially if you want non-technical users to just enter data.

The solution? In the Spanish-speaking developer community, this is often searched as "macro para abrir formulario LibreOffice Base" .