Hi,
I have read about and tried extensively to reference a subform control from another form but to no avail. I hope someone can help.
Name of main form is frmMembers
Name of subform is frmMembersHistory (I' m using Design View/Other tab/Name and not Design View/Data tab/Source Object), which, as I understand, is the correct name to reference the subform from the main form.
I have a button on the main form, which is trying to set the Enabled property of a control on the subform to False.
I am using an embedded macro in the On Click event of this button and I am typing the following in the macro:
Control Name Forms!frmMembers!frmMembersHistory.Form!Membership CategoryID
Property Enabled
Value False
I have tried umpteen varaitions of this with [] and without and guess what ... I get the same 32004 error.
Hope someone can shed some light.
Many thanks,
Seb