Microsoft KB Archive/119708

= ACC2: Scrolling Records with Unbound Combo Box Takes Longer =

Article ID: 119708

Article Last Modified on 11/6/2000

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q119708





SYMPTOMS
Navigating among records can take longer after you search for a record in a form using an unbound combo box.



RESOLUTION
To work around this problem, set the ColumnWidths property for the first column in the combo box to something other than 0 (for example, 0.001), or set the combo box's BoundColumn property to something other than 1.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to Reproduce Problem
 Open the sample database NWIND.MDB. Create a blank, new form based on the Order Details table, and add the Order ID and Unit Price fields to the form.  Add an unbound combo box to the form with the following properties:

     Name: Lookup RowSource: Order Details ColumnCount: 2 ColumnWidths: 0;1 BoundColumn: 1   Create the following macro in the combo box's AfterUpdate property, and then save and close the macro.

     Macro Actions -     GoToControl FindRecord

Action Arguments -     GoToControl Control Name: Order ID     FindRecord Find What: =Forms![Form1]![Lookup] </li> Save the form as Form1 and then switch to Form view. Use the record navigation buttons to scroll through the records.</li> Select a record from the bottom of the Lookup combo box list.</li> After the record you selected is displayed, use the navigation buttons to scroll through the records again. Note that it takes longer to navigate among the records.</li></ol>

<div class="references_section">