Knowledge Base

ACC: Requery Extended Multi-Select List Box Clears Selections

Article ID: 147151

Article Last Modified on 1/19/2007

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.

MORE INFORMATION

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.

REFERENCES

For more information about the MultiSelect property of a list box, search the Help Index for "MultiSelect," and then "MultiSelect property," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbbug KB147151