Referencing subform control from a main form (using an embedded macro)

[Sebbers]

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

[pbaldy]

You are correct that you want the name of the control, not the name of the form itself, if they're different. That looks okay, but try

Forms!frmMembers!frmMembersHistory.Form.Membership CategoryID

What is the text of the error, if you still get it?

[Sebbers]

Hi Paul,

Many thanks for your suggestion but it still does not work.
The error is the same one I get every time:

The control name "Forms!frmMembers!frmMembersHistory.Form.Membershi p CategoryID" is misspelled or refers to a control that does not exist.

I have managed to get it to work with the SetValue command in the embedded macro:

Item [Forms]![frmMembers]![frmMembersHistory].[Form]![MembershipCategoryID].[Enabled]
Value False

This is great from my point of view but it bugs me because I should be able to use SetProperty.

As an alternative I also tried the following in the order below and I got no error:

GoToControl frmMembersHistory
GoToControl MembershipCategoryID

but when I then added:

SetProperty (all sorts of combinations of trying to reference MembershipCategoryID)

the same error came up.

I'm begginning to wonder whether:

a) you cannot use the SetProperty to reference a control in a subform from another form.
b) we've both got the wrong syntax (and I do not believe that for a minute)
c) there is a bug with SetProperty when trying to reference a control in a subform from another form.

Look forward to reading your thoughts or anyone elses.

Thanks

[pbaldy]

I don't use macros, but if you want to post the db I'll play with it and see if I can make it work.