ACC2000: Combo Box Wizard Does Not Allow Selection of Table/Query (208807)

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.
2. Create the following new query, add the Employees table, and save it as qryEmployeeList:

      Query: qryEmployeeList
      -------------------------------------------
      Type: Select Query
   
      Field: EmployeeID
         Table: Employees
      Field: Name:[LastName] & ", " & [FirstName]
         Table: Employees
         Sort: Ascending
   					

3. Open the Employees form in Design view.
4. If it is not turned on, click the Control Wizards button in the toolbox (so that it appears pressed in) to turn on the Control Wizards.
5. Click the Combo Box button in the toolbox, and add a combo box to the header section of the Employees form.
6. Click the Find a record on my form based on the value I selected in my combo box option in Combo Box Wizard, and then click Next. Note that the Combo Box Wizard does not give you the option to select a table or query as the data source for the combo box. Instead, you are presented with a list of all fields available from the RecordSource property of the form.
7. In the Control Wizard dialog box, move the EmployeeId and LastName fields from the Available Fields box to the Selected Fields Box, and then click Next. In the next window, Hide key column is checked, and the first column containing the EmployeeID is hidden. Click Next.
8. In the What label would you like for your combo box? box, type Find Employee, and then click Finish.
9. Open the form in Form view. Note that you can find employees by making selections from the combo box. To use the qryEmployeeList query that you created in step 2 above, you must change the form's RowSource property.
10. Open the Employees form in Design view.
11. Using the right mouse button, click the combo box that you added to the Employees form header section, and then click Properties on the menu that appears.
12. Set the following properties for the combo box:

       RowSourceType: Table/Query
       RowSource: qryEmployeeList
       ColumnCount: 2
       ColumnWidths: 0";2"
       BoundColumn: 1
    					

13. Open the form in Form view. The Find Employees combo box now displays the employees' last names and first names in alphabetical order. Through customizing the combo box, the Combo Box Wizard has added the following code to AfterUpdate property of the combo box:

    Sub Combo43_AfterUpdate()
       'Find the record that matches the control.
       Me.RecordsetCone.FindFirst "[EmployeeID] = " & Me![Combo43]
       Me.Bookmark = Me.RecordsetClone.Bookmark
    End Sub
    						

    NOTE: Your Combo box control may have a name other than Combo43. To further synchronize the form and combo box so that the combo box always displays the name of the employee on the current record when you scroll through the records, add the following code to the form's OnCurrent property event procedure:

    Private Sub Form_Current()
       Me![Combo43] = Me![EmployeeID]
    End Sub
    						

    where [Combo43] is the name of your combo box. Open the form in Form view. Note that the combo box now displays the name of the employee on the current record. You can still use the combo box to find a specific employee.