Re: Reference object

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!gegeweb.org!news.glorb.com!news2.glorb.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!post01.iad.highwinds-media.com!newsfe05.iad.POSTED!c5847af5!not-for-mail
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)
User-Agent	Xnews/5.04.25
X-Antivirus	avast! (VPS 110403-0, 04/03/2011), Outbound message
X-Antivirus-Status	Clean
Lines	29
X-Complaints-To	abuse@teranews.com
NNTP-Posting-Date	Sun, 03 Apr 2011 11:15:56 UTC
Organization	TeraNews.com
Date	Sun, 03 Apr 2011 11:15:56 GMT
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-access:778

Show key headers only | 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