Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208525 - Last Review: June 30, 2004 - Revision: 2.0
ACC2000: Requery Extended Multi-Select List Box Clears Selections
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).
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
- 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.
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.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
others about this knowledge base article
- others about this knowledge base article
|
Report As Irrelevant
|
| Written:
3/9/2005 2:51 AM |
|
|