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?