Re: Reference object

From	<martin@hotmail.com>
Newsgroups	comp.databases.ms-access
References	<62649$4d984bea$5356be6c$21611@cache110.multikabel.net> <in9ptj$lq$1@dont-email.me>
Subject	Re: Reference object
Date	2011-04-03 15:44 +0200
Message-ID	<dafea$4d9879b1$5356be6c$9729@cache110.multikabel.net> (permalink)
Organization	Multikabel

Show all headers | 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