Microsoft KB Archive/147151

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

Article ID: 147151

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q147151



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



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



Steps to Reproduce Problem
 Open any database. Create a form not based on any table or query, and save it as MultiSelectTest.  Add a list box control to the form and set the following properties:      RowSourceType: Value List RowSource: 1;2;3;4 MultiSelect: Extended  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. 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.</li></ol>

<div class="references_section">