>I have a parent/owner form which opens databases, defines recordsets, and declares and populates certain variables.
>
>After loading another child form over the above mentionned parent/owner form I lose the variable values and the objects created including any recordeset, even if they are declared as Public.
>
>1. How can I use the same recordset in the child form (code) without redefining it, and without creating a new workspace?
>
>2. How can I see the values of the variables withiin the child form (code) which were previously defined on the parent/owner form?
When declaring a public variable in a form, other forms can see it if you use the object.property syntax like: ParentForm.Var1.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com