Subform Won't Surrender Focus

[Mod]

Well, the title says it all really. After I click into the subform and type something in a text box, the focus will not return to the parent form, via mouse or tab. I can't even switch the form back into design view, it appears to be totally locked. Has anyone run into this before?

 

[seiky]

you can do it by programming (VBA):

mainForm.Controls("my_control").SetFocus

my_control is a name of a control like a textbox or command button,...

 

[amerfeld]

Me Too!

I have the exact same problem on a database I am working on. The subforms are not modal or popup.

If I select a field and don't update it, the only way I can get out of the subform is to press the escape key twice.
If I do update the value, I'm am ok to go anywhere I want by clicking with the mouse.

To make it more interesting, if I update the subform, move from it, go back into it, select a field, don't make a change, it will let me move out no problem. Huh? I don't get it either!

Tried using the code submitted by seiky but not sure where to use it because there are two fields on my subform I can update and don't want the main form to necessarily receive the focus after they are updated.

Any other ideas?

 

[razorking]

I have the same thing here; one form with two subforms. If I fill in information in the main form and then go to the the second subform to add info to fields there I cannot then go back and edit or change data in any of the fields in the main form or the first subform. The fields just seems locked, no error messages or anything like that just cannot get in to those fields.

I have the user trained to completely fill in one section before moving to the next and he is OK with that, but I am not...I hate creating buggy software

Any ideas?