Microsoft KB Archive/170983

= ACC: Changing Row Source to Table Doesn't Remove Value List =

Article ID: 170983

Article Last Modified on 1/20/2007

-

APPLIES TO


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

-



This article was previously published under Q170983



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



SYMPTOMS
If you try to change the RowSourceType property of a combo box from a value list to a query after the form has been saved, closed, and reopened, the following behavior occurs:


 * The RowSource property of the form will retain the values in the value list.
 * The drop-down list of the combo box on the form will contain the values from the query.
 * A new query, named from the values in the value list, will appear in the Database window.



CAUSE
This behavior occurs if you do not clear out the value list before you try to create the query.



RESOLUTION
Make sure you delete the RowSource property before trying to create the query.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb. Create a new form in Design view not based on any table or query. Add a combo box to the form using the Combo Box wizard. On the first screen of the wizard, click the "I will type in the values I want" option, and then click Next.  In Col1, type the following:

<pre class="fixed_text">   - apples - oranges - peaches - pears - grapes </li> Click Finish to close the wizard. Close and save the form.</li> Reopen the form in Design view, and open the property box for the combo box.</li> Make the following changes:

<ol style="list-style-type: lower-alpha;"> In the RowSourceType box, click to select Table/Query.</li> In the RowSource box, click the Build button.</li> In the Query builder, add the Customers table to the query.</li> Drag the CustomerID field to the query grid.</li> Run and then close the query. Click Yes when asked if you want to save the changes made to the query and update the property. Note that the RecordSource property still shows the value list.</li> Switch the form to Form view and select an item in the combo box list. Note that the list now shows the values from the query.</li> Switch to the Database window. Note that a new query has been added with the values from the value list.</li></ol> </li></ol>

<div class="references_section">