[AccessD] help - syntax for subform

Kath,

Sent a sample db off-list.

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Monday, February 18, 2008 6:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] help - syntax for subform

Don - can you send me a sample of what you got working? I can't get it to
work....

Kath
----- Original Message -----
From: "McGillivray, Don [IT]" <Donald.A.McGillivray at sprint.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, February 19, 2008 11:38 AM
Subject: Re: [AccessD] help - syntax for subform


> Hi Kath,
>
> I don't know how you would refer to the subform within a main form without
> the name of the subform as it appears in the main form.  (Try saying that
> three times really fast . . .)  I made a quick bit of code that accepts
> the main form's name along with the subform's name as an optional
> argument.  The code was able to enumerate the controls on the subform.
> The values were fed to the proc by the OnLoad event of the subform as the
> main form opened.  I used Me.Parent.Name to supply the main form's name,
> and a hard-coded value for the main form's subform control name.  (Dunno
> how else you'd deliver the name of the main form's subform control unless
> it was the same as the subform itself, in which case you could use
> Me.Name, I guess.)  The proc used the following syntax to access the
> subform's controls"
>
> Forms(MainFormName).Controls(SubformName).Form.Controls
>
> Hope this helps
>
> Don
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
> Sent: Monday, February 18, 2008 3:26 PM
> To: Access D Normal List
> Subject: [AccessD] help - syntax for subform
>
> Can anyone help with syntax needed here.....
>
> I have been working on a routine called SecureForm() which locks/disable
> controls for any form which is passed to it.
>
> The routine is called on each form's 'On Load' event and works fine for
> main forms by passing the 'me.name' string.
>
> I now need to add code to the OnLoad of the subforms as well .....so I
> need to pass it the FULL name of the subform (including the full reference
> to the parent name), not just the name of the subform itself.
>
> I have been mucking around with the parent property with no luck so in the
> code below I am trying to get around the error by actually typing in the
> name of the subform but even that is giving me the same error.
>
>
> ------------------------------
> Code is:
>
>    'Call SecureForm function which locks controls, depending on which user
> group is logged in.
>    'strformname = Me.Name            'this works for main forms but not
> subforms
>    strformname = "Forms!FrmPersonDetails!FrmSubformPeopleatWorkplace"
>
>    Call SecureForm(strformname)
> ----------------------------------------
>
> Kath
>
> ______________________________________
> 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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com