Prev: Changes in field won't save
Next: Read Only Record
From: mcnews on 8 Jul 2008 14:11
how can i tell if a form has a parent or not.
i use a form as a subform and as a dialog that opens form a button
click.
i don't need to be told how to design my form.
i need to know how to find out if the form has a parent or not.
isnull(me.parent) doesn't do it.

thanks,
mcnewxp
From: Douglas J. Steele on 8 Jul 2008 14:28
You can refer to its Parent property and trap the error 2452 that'll be
raised if it isn't being used as a subform.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"mcnews" <mcourter(a)mindspring.com> wrote in message
news:ac8b27e1-556e-42f8-b4fa-bbd86115d6ea(a)f36g2000hsa.googlegroups.com...
> how can i tell if a form has a parent or not.
> i use a form as a subform and as a dialog that opens form a button
> click.
> i don't need to be told how to design my form.
> i need to know how to find out if the form has a parent or not.
> isnull(me.parent) doesn't do it.
>
> thanks,
> mcnewxp


From: mcnews on 9 Jul 2008 08:39
On Jul 8, 2:28 pm, "Douglas J. Steele"
<NOSPAM_djsteele(a)NOSPAM_canada.com> wrote:
> You can refer to its Parent property and trap the error 2452 that'll be
> raised if it isn't being used as a subform.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "mcnews" <mcour...(a)mindspring.com> wrote in message
>
> news:ac8b27e1-556e-42f8-b4fa-bbd86115d6ea(a)f36g2000hsa.googlegroups.com...
>
> > how can i tell if a form has a parent or not.
> > i use a form as a subform and as a dialog that opens form a button
> > click.
> > i don't need to be told how to design my form.
> > i need to know how to find out if the form has a parent or not.
> > isnull(me.parent) doesn't do it.
>
> > thanks,
> > mcnewxp

that's it, huh.
that's what i did, but thought might be something a little more
elegant.
thanks.
 | 
Pages: 1
Prev: Changes in field won't save
Next: Read Only Record