Re: Reference object

Newsgroups	comp.databases.ms-access
Subject	Re: Reference object
From	Bob Quintal <rquintal@sPAmpatico.ca>
References	<62649$4d984bea$5356be6c$21611@cache110.multikabel.net>
Message-ID	<Xns9EBC49EE1B902BQuintal@69.16.185.252> (permalink)
Organization	TeraNews.com
Date	2011-04-03 11:15 +0000

Show all headers | View raw

<martin@hotmail.com> wrote in
news:62649$4d984bea$5356be6c$21611@cache110.multikabel.net: 

> In a subform I have this query:
> strSQL = "Delete ID_hyperlink FROM tbHyperlink " & _
>          "WHERE (((ID_hyperlink)=" & 
> [Forms]![frmRequest]![subfrmHypLink].[Form]![ID_hyperlink] & "));"
> 
> Now I want to change the code so I can use it for another main
> form as well like frmArticle:
> [Forms]![frmArticle]![subfrmHypLink].[Form]![ID_hyperlink]
> 
> Unfortunately Parent.Name doesn't work in this case:
> [Forms]!Parent.Name![subfrmHypLink].[Form]![ID_hyperlink]
> 
> Is there a way to easily refer to the right main form in the above
> code? 
> 
> Thanks,
> Martin
> 
> 
Me.Parent.Name![subfrmHypLink].[Form]![ID_hyperlink]



-- 
Bob Q.
PA is y I've altered my address.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Reference object <martin@hotmail.com> - 2011-04-03 12:28 +0200
  Re: Reference object Bob Quintal <rquintal@sPAmpatico.ca> - 2011-04-03 11:15 +0000
  Re: Reference object "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-04-03 08:41 -0400
    Re: Reference object <martin@hotmail.com> - 2011-04-03 15:44 +0200

csiph-web