Setfocus in subform not working

[jason_nevin]

I have a main form with a subform which in-turn also has a subform (in datasheet mode). When the user clicks a button on the main form I want to disable all of the controls on the subforms. This works fine until the user clicks the button while the focus is on one of the text fields in one of the subforms. It rightly complains that the control can't be disbled while it is in focus. To circumvent this problem I've tried setting the focus to another field before disabling the control. However this doesn't seem to work. It seems to ignore the setfocus and still flags the original error. Is it not possible to set the focus of a subform from the main form?

Example:

[subfrm1].Form![Field2].SetFocus
[subfrm1].Form![Field1].Enabled = False

This fails if the focus was in Field1 at the time of executing the code.

Any ideas?

 

[jason_nevin]

I still haven't managed to fix this problem. Any ideas?

 

[pafcpilgrim]

Move the focus to a control on the main form, not on the sub form which is what your code indicates.

 

[jason_nevin]

I've tried that but to no avail I'm afraid.