[AccessD] help - syntax for subform

Try this:

strFormName = Forms("frmPersonDetails")("subPeopleAtWork").Form.Name

In this example 'frmPersonDetails' is the main form.

And subPeopleAtWork is the subform control (not the form).

And .Form is the form within the subform control.

And .Name is the name of the form in the subform control.

HTH!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Monday, February 18, 2008 5: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