Is Control inside Subform

[CementCarver]

I'm trying to determine whether a control belongs to a subform (inside a tabbed page) which is inside my main form. Seems that if you set the following, none of the controls inside a subform get collected:

For each ctl in Screen.ActiveForm.Controls



For Each ctl In Screen.ActiveForm.Controls
If Screen.ActiveForm.ActiveControl.ControlType = acSubform Then... this line not working.....
Debug.Print "Active Control = " & Screen.ActiveForm.ActiveControl.Name
End If


If ctl.Tag = "Audit" Then
Debug.Print "Control Name = " & ctl.Name & vbNewLine & "Control Type = " & ctl.ControlType
End If

[June7]

The only way I know to address controls of a subform is through referencing the subform container control:

With Me.subformname.Form
'code
End With

[NTC]

in the original tabbed pages the data on various tabs are not in subforms but actually a part of the main form & record source.....this was the only tabbed pages approach pre-2007 and maybe what you still have.... the data is simply view-able per tab but actually all part of the same record set.....

but as to the 'active' controls - it is not a method I use typically and so I can't advise as to whether the non viewing controls are considered active or not - - but it would seem this is the other issue that is a candidate to resolve.

maybe helps a little......

[CementCarver]

Thanks NTC, I ended up just testing whether the subform name/controls existed. Although it didn't fix that line I logged the call on, I ended up using another bit of code:

For Each ctl In Forms("frm_EDIT_CURRENT_FULLGROWER").Controls("GRO WER_TRACEABILITY_DATASHEET").Form.Controls

to get past the problem.

CC