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.
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.