Hi,

Wonder if anyone can help. I have a subform within a form that I have disabled as the form opens. Can anyone tell me how to activate the subform after an event such as a mouse click.

Thanks
JA
http://www.access-programmers.co.uk/ubb/smile.gif

Me![ControlNameOfSubform].Enabled=True
should do it.

Remember, you refer to the control in the main form that contains the subform, not the name of the subform itself.

HTH,
RichM

Thanks Rich that seems to have done the trick.

JA