David,

Had a similar problem to yours, MSFT (A) did not understand it and (B) never resolved it.

On the form there was a list box filled by a SQL query and an adjoining grid, attached to a cursor filled by a SQL query. The click even in the list called a SQL statement which filled the cursor. The variable passed to the SQL was "lcwhich_tech". Click, click, click on different names and the grid filled with the related information. TABbing to the grid or CLICKing on it generated the error "Variable lcwhich_tech not found". The grid DID NOT NEED the variable, it had been disconnected from the source cursor to the dummy cursor while the SQL executed and then reconnected.

What really teed me off was that this was textbook-perfect code, everything passed by variables properly scoped, etc., and VFP returned this crap.

Solution? Make lcWhich_Tech a variable scoped to the form, essentially making it global. Yuck!!

Small consolation, but hope this helps - Miles Thompson




>I have a form with a grid showing the child side of a one-to-many
>relationship. The first column contains a drop-down combo displaying
>products. The products in the list is dependent on the user level,
>determined at login. I have populated the list in a variety of ways: first
>with SQL, then with a table. When I use an ordered by clause (with SQL) or
>set an order (with a table), I get a variety of errors, often kicking the
>user out of VFP entirely.
>
>The most common error message is "Variable 'GRIDLINES' not found." Gridlines
>is not my variable; it's obviously a basic grid property, which I never
>access.
>
>The project was originally created in VFP 3.0, where it worked fine, and was
>converted to VFP 5.0 three weeks ago -- and has not worked properly since. I
>have rebuilt the form, rebuilt the data container and all tables. Nothing
>has worked. The error has occured over many machines.
>
>Microsoft has no answer. They believe it is corruption, but I'm beginning to
>think it's a fundamental flaw of VFP.
>
>Has anyone else experience this? Any solutions? If so, PLEASE e-mail me at
>anderson.david@usa.net.
>
>Thanks!