Which control has Focus? 1

[Soundsmith]

I've checked the archives, and had already tried "me.ActiveControl.Name"

But I get an error "The expression you entered requires the control to be in the active window"

I'm in the Current event and am just launching this screen. How do I get it to work?
David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com

 

[Alcar]

did you try to give focus to your control?
Another thing, make sure that when you write me.control you have to write that code on the same form where the control is it.
If you want to refer to a control in another form then you should do this:

Application.Forms("FormName&quot.ActiveControl.SetFocus
msgbox Application.Forms("FormName&quot.ActiveControl.Name

HTH
Alcar

 

[jebry]

Hi!

For a form with controls, the form doesn't get the focus until after the Current event runs. Let us know what you are trying to do and maybe we can come up with a workaround.

Jeff Bridgham

 

[Soundsmith]

Alcar, I was in the form-Jebry gave me the clue - the form doesn't get focus until AFTER current-doesn't make sense to me why it should be that way, but OK. I found a way around the problem.

Thanks for the help. David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com