DOCUMENT:Q150596  24-MAR-2000  [foxpro]
TITLE   :FIX: Error Message "Variable is Not Found" When Running Form
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:3.0,3.0b
OPER/SYS:
KEYWORDS:kberrmsg kbvfp kbvfp300bBUG kbvfp500fix

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b 
-------------------------------------------------------------------------------

SYMPTOMS
========

When you run a form with a grid on it, the error message "Variable Is Not Found"
appears. If you click OK, the form is displayed but the grid is empty. If you
close the form and run it again, the error is not displayed. However, the grid
is still empty.

CAUSE
=====

The ControlSource property of the grid columns is set to a table field that is
not open.

WORKAROUND
==========

Open the table before running the form or add the table to the DataEnvironment
of the form.

STATUS
======

Microsoft has confirmed this to be a problem in the Microsoft products listed at
the beginning of this article. This problem has been fixed in Visual FoxPro 5.0
for Windows.

MORE INFORMATION
================

This behavior occurs because the grid columns have a ControlSource set to a
field that cannot be found because the table has not been opened.

Steps to Reproduce Problem
--------------------------

1. Create a new form.

2. Add the Customer table from the \VFP\Samples\Data directory to the
   DataEnvironment of the form.

3. Drag the Cursor object from the DataEnvironment and drop it on the form to
   create a grid.

4. Set the following properties for the grid:

   Grid1.ColumnCount = 2
   Grid1.Column1.ControlSource = Cust_id
   Grid1.Column2.ControlSource = Company

5. Save and run the form. Note that the grid has information in it. Close the
   form and modify it.

6. Open the DataEnvironment, and delete the Cursor1 object. Save and run the
   form.

7. The error "Variable Is Not Found" is displayed.

8. Click OK, and the form is displayed but the grid is empty.

NOTE: If you close the form and run it again, you do not see the error message,
but the grid is still empty. Running the form after exiting and restarting
Visual FoxPro causes the error message to be displayed.

Additional query words:

======================================================================
Keywords          : kberrmsg kbvfp kbvfp300bBUG kbvfp500fix 
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b
Version           : WINDOWS:3.0,3.0b
Issue type        : kbbug
Solution Type     : kbfix

=============================================================================

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.

Copyright Microsoft Corporation 2000.