Bruce Bruen
bbruen at bigpond.com
Tue Mar 11 19:02:00 CST 2003
Hi List, I am trying to use a form that may appear as a subform or on its own. If its a subform then I want to maximise it in its parent control space, if not then it should be sized to fit the form. But how do I tell where it is being opened? The following doesn't work: On Error Resume Next If Not IsNull(Me.Parent.Name) Then boolIsSubform = True DoCmd.Maximize Else boolIsSubform = False End If On Error GoTo 0 Ignore the fact that the docmd works on the parent, I am not worried about that at the moment, only that I dont know how to test the "subformedness". Tia Bruce --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003