Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

First make sure you database is registered. You cannot access databases that are not registered. This list is from menu Tools->Options->LibreOffice Base->Databases. If not listed, you can add it using New and point to the .odb location.

If not on already, turn on the Form Design toolbar (menu View->Toolbars) and then turn on Form Controls toolbar (floating toolbar). Select the List Box tool from the Form Control toolbar and on the document hold down left mouse button and drag to size the object.

If Wizards are ON you can follow that or do it yourself as follows.

Now you need to add information to the object. From the Form Design toolbar, click on the Form Navigator icon. You should now see this:

image description

Right click on Form and select Properties. image description

In the Data tab, Data Source select the database where the table is located. Content Type should be Table and in Content select the table which contains the data for your list. The form is now set so close properties.

From the Form Navigator right click on the List Box 1 (unless you renamed it) and select Properties.

image description

Again from the Data tab, set Data Field to the column where you values are, Type of list contents to Sql, use the ellipsis to the right of List content to set the column for the data list, and finally set Bound field to 0 (signifying the first field).

If all went right, click on Toggle Design Mode on the Form Design toolbar and your list box should be filled.