>I posted this yesterday, but it got lost somehow.....
>
>My form has three tables in the dataenvironment, in a parent-child-child relationship. I set the filter as a property as follows:
>
> Parent: None
> Child1: Child1.key = Parent.key
> Child2: Child2.Key2 = Child1.key2
>
>The data from each appears in a standard listbox, with a RowSourceType of 6 and a RowSource as appropriate, usually the description field. The Child2 table listbox has a rowsource of 4 fields, numeric/character/datetime/numeric.
>
>In the InteractiveChange event of lstParent, I issue:
> lstChild1.Requery
> lstChild2.Requery
>In the INterActiveChange event of lstChild1, I issue:
> lstChild2.Requery
>
>The lstChild2.Requery is suddenly returning a "Syntax error" error message. There is no code in the lstChild2.Requery event. It has been working fine, and just developed this twitch.
>
>If I change the RowSource of lstChild2 to eliminate the first column, it seems to like it better, but I haven't really road-tested it.
>
>Clues?
>
>BTW, this is VFP 3.0/Mac.
Try rebuilding you project, then pack it. I would then "use" the formname.scx and pack it to make sure that old deleted records were removed. Not sure this will help but it is always the first thing I do when I start getting weird problems.
HTH //:^)