Access 2016 Intermediate

Access 2016

Lesson 11 – Using Advanced Form Design

12. Select

.

13. Select . 14. Select the desired storage option for the field. 15. Select the Store that value in this field list, if applicable. 16. Select the desired field name, if applicable.

17. Select . 18. Type a label for the combo box.

19. Select

.



Step-by-Step

From the Student Data directory, open ADVFORM.ACCDB . Create a combo box on a form.

Open the Order Entry form in Design view. If necessary, display the ruler.

Steps

Practice Data

1. Select the Design tab on the Ribbon . The Design tab appears. 2. Select the Combo Box button in the Controls group. The mouse pointer changes into a copy of the tool with a plus sign (+) when positioned over the form. 3. Click in the form in the location where you want the combo box to appear. An outline of the combo box appears on the form and the Combo Box Wizard opens.

Click Design

Click

Click just under the Customer ID text box

4. Select the desired option for the source of the combo box values.

Click I want the combo box to get the values from another table or query. , if necessary

The desired source option is selected.

OFFICEPRO, Inc.

Page 197