PRB: Data Type Error Inserting Data Outline Control

Article ID: Q120481
Creation Date: 12-SEP-1994
Revision Date: 05-FEB-1996

The information in this article applies to:

Microsoft Access Developer's Toolkit version 2.0

SYMPTOMS

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

When you are defining relationships with the data outline control, you may receive the following error message:

   One of the specified RecordSources is invalid

CAUSE

The fields for which you are trying to define a relationship have different data types.

RESOLUTION

Make sure to define relationships only for fields that have the same data type.

STATUS

This problem no longer occurs in Microsoft Access Developer's Toolkit version 7.0.

MORE INFORMATION

The data outline control is included with the Microsoft Access Developer's Toolkit (ADT). You can use this control to define relationships between fields so that you can expand or collapse data linked on those fields. The Data Outline Control Wizard does not prevent you from defining relationships for fields with different data types, but when you try to expand such a level in the data outline control, you will receive an error message.

Steps to Reproduce Behavior

Open the sample database NWIND.MDB.
Create a new form not based on a table or query. Make sure that the Control Wizards button in the toolbox is selected (the button should appear sunken).
From the Edit menu, choose Insert Object. In the Insert Object dialog box, select the Insert Control option button, then select Data Outline Control in the Control Type box. Choose OK.
In the "For each level, what data do you want the Data Outline Control to display?" screen, select the Categories table in the Table/Query box for level 1, and then choose the Next Level button.
For level 2, select the Orders table in the Table/Query box, and then choose OK when you are prompted "You must define a relationship between the data on this level and the previous level."
Choose the Define Relationship button. In the Categories box, select Category ID. In the Orders box, select Freight. Choose OK.
Choose the Finish button.
View the form in Form view.
Expand any of the levels in the control. Note that you receive the error message mentioned earlier in this article.

REFERENCES

For more information about the data outline control, see the Overview topic in the Data Outline Control Help included with the ADT.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.