ACC2000: Requery Extended Multi-Select List Box Clears Selections (208525)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q208525
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

List boxes have a property called MultiSelect that enables you to make multiple selections in one control. If the MultiSelect property is set to Extended, any selections that you make are cleared if the list box is requeried. This behavior does not occur if the MultiSelect property of the list box is set to Simple or None.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Access 2000.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start Microsoft Access and open any database.
  2. Create a form not based on any table or query, and then save it as MultiSelectTest.
  3. Add a list box control to the form, and then set the following properties:

    RowSourceType: Value List
    RowSource: 1;2;3;4
    MultiSelect: Extended

  4. On the View menu, click Form View, and then select an item or two in the list box by pressing and holding the CONTROL key as you make your selections.
  5. Press CTRL+G to open the Immediate window, type the following line, and then press ENTER:

    Forms![MultiSelectTest]!List0.Requery

    Note that your selections are lost.

REFERENCES

For more information about the MultiSelect property of a list box, click Microsoft Access Help on the Help menu, type multiselect property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/30/2004
Keywords:kbbug kbpending KB208525
©2004 Microsoft Corporation. All rights reserved.