Modify a subform from another subform with VBA 1

[metaltree]

I have a menu form (form1) and 2 subforms (subform1 & 2).

When I update data in subform1, I want to disable subform2.

I tried from subform1

Private Sub field1_AfterUpdate()
Forms![subform2].Disable
End Sub

but VBA keeps telling me that he is unable to find that name.

Any ideas?

 

[metaltree]

Please, ignore my last piece of code, here is the right one (that doesn't work):

From subform1

Private Sub field1_AfterUpdate()
Forms![subform2].Enabled = False
End Sub

Where subform2 stands for the name of the form (source object in properties)


However, the following code works:

From form1

Private Sub button1_Click()
...
Me![subform2].Enabled = False
End Sub

Where subform2 stands for the name of the subform (name in properties)


How to disable subform2 from subform1?

 

[Remou]

Subforms must be refered to as parts of the form that they are on:

http://www.mvps.org/access/forms/frm0031.htm

 

[metaltree]

Awesome.
Thanks!

 

[TheAceMan1]

or you could use the following:

[blue]   Me.Parent![[purple][B][I]subForm2Name[/I][/B][/purple]].Enabled = False[/blue]

Here Parent refers to the Mainform . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[metaltree]

Thanks AceMan1, I'll try that.