ACC: Requery Extended Multi-Select List Box Clears Selections

• Microsoft Access versions 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

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 you make will be 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 this to be a problem in Microsoft Access 7.0 and Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it become available.

MORE INFORMATION

Steps to Reproduce Problem

1. Open any database.

2. Create a form not based on any table or query, and save it as MultiSelectTest.

3. Add a list box control to the form and set the following properties:

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

4. On the View menu, click Form View ( or click Form in Microsoft Access 7.0) and select an item or two in the list box.

5. Press CTRL+G to invoke the Debug window, type the following line, and then press ENTER:

         Forms![MultiSelectTest]!List0.Requery
   

   Note that your selection(s) are lost.

REFERENCES