ADG


Hi

I am trying to enable and disable textbox controls on a subform when a field on my parent form changes. It appears that the subform textboxes are not visible to VBA when I am trying to write the code. Can anyone give me an example of enabling and disabling controls on a subform

Regards

ADG




Re: Enable and Disable text boxes on a sub-form

ADG


I have worked around the problem. I could not refer to the sub-form control by name so I have looped through all the items in the controls collection to check there names then used the item to refer to the properties. Does anyone know why I cannot use control name to refer to controls on a sub-form