Re: Reference object

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!gegeweb.org!aioe.org!feeder.news-service.com!xlned.com!feeder3.xlned.com!multikabel.net!newsfeed10.multikabel.net!post30.multikabel.net!cache110.multikabel.net!not-for-mail
From	<martin@hotmail.com>
Newsgroups	comp.databases.ms-access
References	<62649$4d984bea$5356be6c$21611@cache110.multikabel.net> <in9ptj$lq$1@dont-email.me>
In-Reply-To	<in9ptj$lq$1@dont-email.me>
Subject	Re: Reference object
Date	Sun, 3 Apr 2011 15:44:11 +0200
MIME-Version	1.0
Content-Type	text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding	7bit
X-Priority	3
X-MSMail-Priority	Normal
Importance	Normal
X-Newsreader	Microsoft Windows Live Mail 15.4.3508.1109
X-MimeOLE	Produced By Microsoft MimeOLE V15.4.3508.1109
Message-ID	<dafea$4d9879b1$5356be6c$9729@cache110.multikabel.net> (permalink)
X-Complaints-To	abuse.cas.news@prolocation.net
Organization	Multikabel
Lines	33
NNTP-Posting-Host	83.86.190.108 (83.86.190.108)
NNTP-Posting-Date	Sun, 03 Apr 2011 15:44:17 +0200
X-Trace	dafea4d9879b1f6f31bc909729
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-access:782

Show key headers only | View raw

Thanks. I got it working.

Martin


"Douglas J Steele"  schreef in bericht news:in9ptj$lq$1@dont-email.me... 

As it implies, Parent.Name returns the name of the object: you want the 
object itself.

Use

Me.Parent![subfrmHypLink].[Form]![ID_hyperlink]

wrote in message 
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

Back to comp.databases.ms-access | Previous | Next — Previous 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