Last week Mike Kaganski (a Russian developer) asked me to correct some things in the Help. If the form is related to a database and the database connection is active, the combo box wizard opens automatically after inserting the combo box into the document. You can assign the combo box the “read-only” property so that users cannot type entries other than those in the list. A combo box is a single-line list with a drop-down list from which users can choose an option. This wizard helps you to set up the table.Ĭreate a combo box. If the form is linked to a database and the database connection is active, the List Box Wizard will automatically appear after inserting the list box in the document. The list box allows users to select an entry from a list.

Normally, they are given a group box.Ĭreates a list box. Option buttons with the same functionality are given the same name (Name property). Option buttons enable the user to choose one of several options. To include a label for the field, hold down CommandCtrl+Shift when you drag a column head.Ĭreates an option button. In a text document, you can also drag a column header to add a field to a form.

To add a field from the field list of a table or query to a form, drag a cell into the form. The four possibilities, from left to right are In columns-Labels on left, In columns-Labels on top, As datasheet and In blocks-Labels on top. In this step of the form creation we determine where the labels are placed in relation to the fields. That is why we use the Date field from both tables: both are of type Date.Įach control in a form consists of two parts: label and field. When selecting a pair of fields from two tables to use in a relationship, they have to be of the same type.

Simple forms need only a few of these steps, while more complex forms may use all of them. In the task list, double-click on Use the wizard to create form to open the Form Wizard (see image).

In the main database window (see image), click on the Forms icon in the left column. The is made from the same table with a label (Fuel Expenses), a pick list placed on the payment form and a background graphic. Other more complex forms can contain many more things, including additional text, graphics, checkboxes and many other elements. 3.1 How to make a form in libreoffice writerĪ simple form consists of a series of fields in a table (see image).1 Crear formulario con openoffice writer.

Partes de openoffice writer