screen.activeform on a sub

[patfee]

Hi,
how can i derive the name of a subform (nested in a main form) like you can do on the main form by using screen.activeform.

i.e. when i click a button on a subform, the screen.active form returns the name of the main form... while i'm looking for the name of the subform....

Thanks,
Pat

 

[Eupher]

patfee,

Me.Parent.Name

Ken S.

 

[TheAceMan1]

How are ya patfee . . . . .

Directly no can do, however the [blue]Parent[/blue] of most controls are the form/subform where they reside, so:

[blue]Screen.ActiveControl.Parent.Name[/blue]

When using the [blue]Parent[/blue] property be aware of controls in controls. A checkbox in an option group for instance would return the option group instead of the form.

See Ya! . . . . . .