how to know if your in a subform??? 1

[din2005]

Hey all i have this subform with a check boxbut also u can maximise this subform to see all the form.

Now about the checkbox i want it to do the same functionality in the after update if it was maximised or if it was in a subform... can this be possible?

i.e

check if u r in subform and do the appropriate action or

if form is maximised then do the appropriate action.

many thanks

 

[Remou]

I do not understand your point, code on a subform should work the same no matter whether it is maximised or not.

 

[MajP]

Public Function isSubForm(frm As Access.Form) As Boolean
  On Error GoTo errLabel
  isSubForm = (frm.Parent.Name = frm.Parent.Name)
  Exit Function
errLabel:
  If Err.Number = 2452 Then
    Err.Clear
   Else
    MsgBox Err.Number & "  " & Err.Description
  End If
End Function