Accessing a subform control from another subform

[theosgood]

How do I reference a subform control from another subform?



Main Form: frmOfferCreate
Subform 1: frmVendorSelect
Subform 2: frmSku Select Activate

Subform 2 has a hidden button (cmdChangeVendor) (should only be visible if you use subform 1). When in subform 1, when I hit continue, it runs a macro that runs queries and opens subform 2. I want to set the property of the button in subform 2 to visible. You can also access subform 2 from another location, so I can't use the On Load property.

In the macro I have:
Action = SetProperty with Control name = subform string, Property = Visible, Value = Yes

I have tried the following subform strings:

Forms![frmOfferCreate]![frmSku Select Activate].Form![cmdChangeVendor] - error cant find the form "frmSku Select Active" referred...
Form_frmOfferCreate![frmSku Select Activate].Form![cmdChangeVendor] - error cant find the field "frmSku Select Activate" referred ....
Forms("frmOfferCreate")![frmSku Select Activate].Form![cmdChangeVendor] - error cant find the form "frmOfferCreate" referred....

Any other suggestions?

[amrut]

Have a look here - http://access.mvps.org/access/forms/frm0031.htm

[theosgood]

Thanks. This is a great reference and I am sure it will come in handy. I also found another at http://ss64.com/access/syntax-references.html However, I still can't get sub1 to talk to sub2. Enough for today.