Shifting focus from a subform to its mainform

[marblegiant]

Worked out how to move focus from a mainform to a subform, using a macro, by using Gotocontrol and selecting the subform as the control. But can't work out how, again using a macro, it's possible to shift focus back to the mainform from the subform. All ideas appreciated! Many thanks. W

 

[jdwhytie]

Use SelectObject in your macro

 

[marblegiant]

Hi, thanks for that.

But I'm clearly still doing something wrong. When I shift focus from the sub to the main form I then want to hide (set value visible no) the sub.

But even though I'm now using SelectObject to shift focus to the main I get a macro error saying that I can't 'hide a control that has focus'!!

Any other ideas MUCH appreciated!

 

[sonny]

Hi, thanks for that.

But I'm clearly still doing something wrong. When I shift focus from the sub to the main form I then want to hide (set value visible no) the sub.

But even though I'm now using SelectObject to shift focus to the main I get a macro error saying that I can't 'hide a control that has focus'!!

Any other ideas MUCH appreciated!

Just set focus to some other control first in your order of things.. that way the control your trying to hide doesnt have the focus....

 

[Mile-O]

Me.Parent.ControlName.SetFocus