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

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

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 : FmsCmbo
Version : 7.0 97
Platform : WINDOWS
Issue type : kbbug