Disabling all subform controls 1

[RoyVidar]

Hi!

Given a criteria on my main form, I want to disable all controls on my subform.

I do that now bo looping thru the controls (For Each...) and it works fine except for one thing. One of the subform controls has focus, even if the focus is on the main form. So it produces an error (can't disable a control that has focus).

I've "solved";-) it by adding another control to the subform and give it the focus, but isn't there a more elegant way?

Thanx, Roy-Vidar

 

[ghubbell]

How about this:
Your subform is a control on the mainform so:

Me![NameOfSomeOtherControl].Setfocus
Me![NameOfSubFormAsSeenByTheMainForm].Locked = True

Give it a try!
Gord
ghubbell@total.net