Page 19 of 31PREVNEXT

Combo boxes, list boxes, and other controls

Expression Builder dialog box

Callout 1 Expression box shows the expression as you create it. Here the UnitPrice field of the Products table is divided by the QuantityPerUnit field of the same table.
Callout 2 Buttons speed up entry of commonly used operators, such as plus sign and equal sign.
Callout 3 Elements include tables, queries, and forms, their fields and controls, and any values assigned to those.

Controls can do more than enter or display data. They can work with data to produce temporary results, leaving the database unchanged. Suppose, for example, you want a control to divide unit prices by the number of items in a product unit, to show the price per item.

Calculated controls work by means of expressions. An expression combines arithmetic operators, fields, prebuilt formulas, and values to produce a sum. An expression can use data from a table, a query, or another control.

To create an expression, you would select the control, click the Properties button Button image, and select the Data tab. Beside the Control Source property box, you would see three dots. Clicking those would open the Expression Builder dialog box.

In the dialog box, you could choose from lists of elements and enter specific values to perform a calculation. You’ll get a chance to try that in the practice session for this lesson.

Page 19 of 31PREVNEXT