Microsoft KB Archive/209719

= ACC2000: DDE Statements Invalid in List Box or Combo Box Control =

Article ID: 209719

Article Last Modified on 12/12/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209719



Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
If you use a dynamic data exchange (DDE) function as the ControlSource property of a list box or a combo box, the box will be empty when you view it in Form view. However, if you view the form in Datasheet view, the first object in the DDE data will appear.

Using a DDE function in the RowSource property causes an error message in both Form and Datasheet views of the form.



RESOLUTION
Using code, you can create a list function that returns to a list box or combo box. You can use any code routine to obtain the information used in the list, including DDE commands.



STATUS
This behavior is by design.



MORE INFORMATION
The ControlSource property of a list box or combo box may be blank if the control is unbound, or may contain the name of the field that the control is bound to; it may not contain a DDE function.

The RowSource property of a list box or combo box may contain a list of values, the name of a table or query, or an SQL string. This property provides the list of values that the user may select from.

Steps to Reproduce Behavior
 Open a Microsoft Excel spreadsheet and enter a text string in cell A1. Save the spreadsheet as Test.xls, but do not close the spreadsheet. Leave Test.xls open.  Create a new form in Microsoft Access and add a list box with the following property setting:   Object: List Box --  ControlSource: =DDE("Excel","Test.xls","R1C1")  View the form in Form view. Note that the list box is empty in Form View. View the form in Datasheet view. Note that the data from Microsoft Excel appears in the list.</li></ol>

<div class="references_section">