ACC2: Scrolling Records with Unbound Combo Box Takes Longer

• Microsoft Access version 2.0

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.

MORE INFORMATION

Steps to Reproduce Problem

1. Open the sample database NWIND.MDB.

2. Create a blank, new form based on the Order Details table, and add the Order ID and Unit Price fields to the form.

3. Add an unbound combo box to the form with the following properties:

         Name: Lookup
         RowSource: Order Details
         ColumnCount: 2
         ColumnWidths: 0;1
         BoundColumn: 1
   

4. 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]
   
   

5. Save the form as Form1 and then switch to Form view. Use the record navigation buttons to scroll through the records.

6. Select a record from the bottom of the Lookup combo box list.

7. 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.

REFERENCES

Microsoft Access "User's Guide," version 2.0, Chapter 25, "Using Macros with Forms," pages 651-652