ACC2: Scrolling Records with Unbound Combo Box Takes Longer
ID: Q119708
|
The information in this article applies to:
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 : kbusage FmsCmbo
Version : 2.0
Platform : WINDOWS
Issue type : kbbug