Howard,
Do both form objects share the same data session? If yes, then they should see the view.
>I am creating a SQL view in an object (Object 1) - the main part of my program.
>
>I want to open another form by doing a CREATEOBJECT of the class that is the form (Object 2). There are grids in Object 2's form, and there are RowSource references to the views created in Object 1.
>
>Should that second object (Object 2) be able to see and use the SQL Views created by Object 1?
>I am getting an error - "field" phrase is not found (Error 1130) - when I do the CREATEOBJECT, and I am guessing that it is due to the RowSource view references.
>
>This all works fine if I use DO FORM on the form version of this class rather than CREATEOBJECT on the class.
>
>Not sure that this matters, but the program is an .exe COM server.
>
>Thanks,
>Howard
If it's not broken, fix it until it is.
My Blog