[AccessD] amending code for variable form name - Syntax help

Kath,

I remember doing something similar a while back, where I needed to remember
the name of the form which opened another form.  Unfortunately I can't find
my code, but try something like below:

Forms(frmCallingForm).Form.Visible = True

If that doesn't work, try without the .Form:

Forms(frmCallingForm).Visible = True

Paul Hartland

2008/7/15 Kath Pelletti <kp at sdsonline.net>:

> Need some syntax help.
>
> I need to set a form's visible property to true. It works if I explicity
> use the form name, eg.
>
> Forms!frmPersonDetails.Form.Visible = True
>
> But where I use a variable eg:
>
>    Forms!frmCallingForm.Form.Visible = True
>
> it doesn;t. How do I amend the code to include the variable frmcallingform?
> The code which creates and sets the variable form name is shown below:
>
> Dim frmCallingForm  As Form
> Set frmCallingForm = Forms("frmPersonDetails")
>
>
> ______________________________________
> Kath Pelletti
> Software Design and Solutions Pty Ltd
> Ph: 9505-6714
> Fax: 9505-6430
> kp at sdsonline.net
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com