Creating a 'Menu' form or Console

I want a top-level form which lists other forms for the user to open - a sort of ‘menu’ which I prefer to call a ‘Console’. I have created a form ‘Console’ and have added several Label fields representing the forms available. However, I can’t make any sense of the instructions in BH40-BaseHandbook.pdf, page 225 under the heading ‘Navigation from one form to another’ as regards macro creation. They mention the ‘Additional information’ field as the place to enter the name of the form to open, and give an example of a suitable macro, but give no indication of where this macro should be defined and what event should be used to trigger it. Help please.


Unfortunately many who create an account here to ask a question never bother to try and comprehend how the site works. When you have signed in you are on the main page. On that page, there, in the right hand column, is a section called Resources. Please take just a minute or two to read How to use the Ask site. It’s not all encompassing but will provide basic information to ask a bit better question than you have.

There are also a few other links at the bottom of the page - FAQ & Help which are often overlooked and contain other information.

As was mentioned in your last question, you don’t specify the database you are using. Although probable not an issue here, each question you should include some essentials - OS, specific LO version, and for Base the database being used. Not providing this information can delay in getting an answer.

Thanks Ratslinger. I’m a newbie. I’ll try to adhere to the conventions in future.

OK, for ongoing reference:

Operating system: Windows 10 Pro
Version of LibreOffice: Version: (x64)
File format: ODB
Database engine: Firebird


First you skipped right to some code. At the beginning of that chapter is how to create a library and where to place the macros.

Now the is no reason to expect labels to do much of anything. Push buttons will probably be of better use. Additional Information is a property (General tab) of a control → see page 70. Also in properties under the Events tab are actions you can attach macros to. For example when a button is pushed you can run a macro attached to the Execute action event. See → Events and Events_2. You use the ellipsis to select your macro to be attached.

Now this is just skimming the subject as when dealing with macros there is a lot to cover and will not be learned in any short period of time. For more information on macros see this post → To learn LibreOffice Base are there introductions or tutorials? and for macros look in the answer under BASE / MACRO DOCUMENTATION and INDEPENDENT DOCUMENTATION. The best single guide is Macros Explained - OOME_3_0 - link is provided.

Macro coding/creation in LO is quite a task!


As an alternative, and no macros involved, you may want to consider → [Tutorial] Standalone Forms / Switchboard

As with ALL questions, if this answers your question please tick the :heavy_check_mark: (upper left area of answer). It helps others to know there was an accepted answer.