The single form method requires some care to be user friendly and generally the sub-form route is more flexible and thus preferable.

(Choose the Wizard or design view.) <> 3. User community support forum for Apache OpenOffice, LibreOffice and all the derivatives.

As soon as changes in the source fields are made and the record is saved, the calculated field should immediately display its updated value. (File > New > Database, select the first radio button in that window and continue.) 2. The document might be any LibreOffice/OpenOffice document, a Base form or report, etc. Furthermore to avoid false errors when a new record is added, the calculated field must also have its 'Input required' property set to 'No'. (Q) How do I simulate a calculated field on a form //AOO/LibO. Continue to drag field names into your form letter. Thus, with the calculated field included in the same form as the other fields, its control should be set as read only (or not enabled) to avoid the risk of inadvertently changing the value of the calculated field instead of the fields on which the calculation is based. uses fields (calculated data) to create page numbers. Click on the field and click on the button to move the field to the Fields in the form list. OpenOffice Base form displaying first record from Northwind products. You cannot perform calculations on numbers stored in a text field.

The form must be sourced from a query and if it is to suitable for adding or editing records it is simpler if the source query is sourced from a single table. Calculated fields derive their values from data that exists elsewhere in the database. In addition to the use of a sub-form in the above example it is now possible in some circumstances to have a single Base form containing the calculated field together with the other fields on which the calculation is based. Yes, as shown by Villeroy's example that is the requirement - my apologies for not having made it clear that calculated fields are most easily created and handled within queries.

I need to use the calculated field (is that the right term?) in the Query as a source for a field in the Form.

Openoffice base calculated field form