Knowledge Base

ACC2: Scrolling Records with Unbound Combo Box Takes Longer

Article ID: 119708

Article Last Modified on 11/6/2000

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.

MORE INFORMATION

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]

Save the form as Form1 and then switch to Form view. Use the record navigation buttons to scroll through the records.
Select a record from the bottom of the Lookup combo box list.
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

Additional query words: retrieve moving performance

Keywords: kbbug kbusage KB119708