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