The field corresponds to a column in the table you created.Ĭlick 'Next,' and then choose whether you want to save the value chosen for the drop-down box to a field on the table. Select the correct table from the 'Table/Query' box if more than one table is preset in your database.Ĭlick 'Next,' choose the same table again for the Control, click 'Next' again, and then select which field you want to use for the drop-down menu content. When you release the button, the Combo Box Wizard opens.Ĭlick the 'Browse' button, and then choose your database as the data source for your drop-down menu. Click-and-drag the cursor to draw the shape and size of the drop-down menu. Click 'View,' select 'Toolbars,' and then click 'Form Controls.' If design mode is not automatically enabled, click the icon to enable it - it looks like a finger cursor pointing to the word 'OK,' and is the second button on the toolbar.Ĭlick the Combo Box icon, which looks like a drop-down menu. To create the form in Base, click 'Forms,' and then select 'Create Form in Design View.' For creating the form in another document, such as Writer, open that document.Įnable the Form Controls toolbar, if it is not already visible.

Click 'Save' when done, and then close the table. If you have five rows, you will have five items in the menu. Every row will correspond to an item in your drop-down menu. Each row needs a unique ID number enter any number you want.

For your basic drop-down menu, this is not necessary.Įnter the values for your drop-down list in the appropriate column. You need at least one field in the table the drop-down list only pulls content from one field.Ĭlick 'Finish' after selecting the field types you want to use the only reason to run through the whole wizard is if you want to change the default settings for the fields. Select 'Tables,' and then choose 'Use Wizard to Create Table.' This option gives you several preconfigured table fields to work with, such as Model Number or Category.

Create a table to act as the content source for the drop-down list, if you do not already have one set up.

Libreoffice writer 4.1