ACC2: Combo Box Reference Returns Next Row If ColumnHeads = Yes

MORE INFORMATION

Steps To Reproduce Problem

1. Open the sample database NWIND.mdb.
2. Create a new, blank form in Design view.
3. Add a combo box to the form, and set the following properties:

   Name: CtlEmployeesCmb
   RowSource: Employees
   ColumnCount: 3
   ColumnWidths: 1 in; 1 in; 1 in
   ColumnHeads: Yes
   BoundColumn: 1

4. Set the AfterUpdate property of the combo box to the following [Event Procedure]:

         Sub CtlEmployeesCmb_AfterUpdate ()
            [CtlEmployeesCmb].Requery
         End Sub
   						

5. Add a text box to the form and set the following property:

   ControlSource: =[CtlEmployeesCmb].Column(2)

6. View the form in Form view.
7. Select an item in the combo box. Note that the text box displays the name of the employee in the next row down from the selected row.