Microsoft KB Archive/208525

= ACC2000: Requery Extended Multi-Select List Box Clears Selections =

Article ID: 208525

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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

RowSourceType: Value List

RowSource: 1;2;3;4

MultiSelect: Extended

 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. 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.</ol>

<div class="references_section">