ACC2000: Requery Extended Multi-Select List Box Clears Selections

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.

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

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.

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.