Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Create a new Query in Design View. Close the Add Table dialog box. From the Query menu, select SQL Specific, and then click Union. Add the following SQL statement to the Query: SELECT LastName & ", " & FirstName, EmployeeID FROM Employees UNION SELECT '(All)', null FROM Employees Save the Query as EmpUnionAll, and then close the Query. Open the Employees form in Design view. Double-click on the ReportsTo combo box to bring up the control properties. On the Data tab of the Properties box, change the Row Source to the EmpUnionAll query that you created above. Change the Bound Column property on the Data tab from 1 to 2. On the Format tab, change the column width from 0 to 2;0. Open the form in Form view. Notice that you can now select '(All)' from the combo box list.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.