Groups | Search | Server Info | Login | Register


Groups > comp.databases.ms-access > #777

Reference object

From <martin@hotmail.com>
Newsgroups comp.databases.ms-access
Subject Reference object
Date 2011-04-03 12:28 +0200
Message-ID <62649$4d984bea$5356be6c$21611@cache110.multikabel.net> (permalink)
Organization Multikabel

Show all headers | View raw


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 | NextNext 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