Share this Page URL

Chapter 7. Designing Basic Forms > Adding a Control to a Form - Pg. 264

Designing Basic Forms 3. 264 4. 5. Right-click the AssignedTo combo box, and then click Properties. In the Properties dialog box, the Control Source property for this field is already set to As- signedTo. However, we need to set the Row Source property for the combo box before the list shows the values we want. The row source for a combo box is similar to the record source for a form. The Row Source property defines the source of the data that the combo box dis- plays. In this example, we also need to adjust several other properties of the combo box so that it displays and stores the data the way we want it to. Click in the Row Source property, and then click the Build button. In the Query Builder window, select Employees in the Show Table dialog box, click Add, and then click Close. The Query Builder window now looks like the following: