Determine If a Contol Has Focus

[mtwildtrout]

Is there a way to determine if a control has focus from VB code? I need to determine if a command button has focus so I can trigger some additional code. I would envision the code to be placed in the Before Update or Close event.

Also, is there a way to know if the user has clicked the "X" close window button on a form?

 

[DanJR]

see the help file for "ActiveControl"

e.g. (within a form)
if me.activecontrol.name = "cmdButton" then
....
end if


if no control has focus then an error will occur

Cheers,
Dan

 

[Talgo]

Dan,

Thanks for putting me in the right direction!

Don