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: Newsgroups: comp.databases.ms-access References: <62649$4d984bea$5356be6c$21611@cache110.multikabel.net> In-Reply-To: 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: 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 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