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

<martin (AT) hotmail (DOT) com> wrote in
news:62649$4d984bea$5356be6c$21611 (AT) cache110 (DOT) multikabel.net:




--
Bob Q.
PA is y I've altered my address.

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 (AT) cache110 (DOT) 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

Thanks. I got it working.

Martin


"Douglas J Steele" schreef in bericht news:in9ptj$lq$1 (AT) dont-email (DOT) 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 (AT) cache110 (DOT) 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