This should be a quickie:

How do I capture the current control the user is on? I've declared a
variable "Ctl" and want to save the current control in that variable. The
user goes to an input window and when returning, I want to put the cursor
back to the control the user was on.

TIA

--
sam

Screen.ActiveControl.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"smk23" <(E-Mail Removed)> wrote in message
news:CF4DE0B9-E846-4BED-8512-(E-Mail Removed)...
> This should be a quickie:
>
> How do I capture the current control the user is on? I've declared a
> variable "Ctl" and want to save the current control in that variable. The
> user goes to an input window and when returning, I want to put the cursor
> back to the control the user was on.
>
> TIA
>
> --
> sam

Thanks, Doug. Appreciate your help as always.
That was the first thing I looked for and couldn't seem to find it in the
list!! In any case, I had to go with

Screen.PreviousControl
becase ActiveControl took me back to the command button and kept re-opening
the input box.

"Douglas J. Steele" wrote:

> Screen.ActiveControl.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "smk23" <(E-Mail Removed)> wrote in message
> news:CF4DE0B9-E846-4BED-8512-(E-Mail Removed)...
> > This should be a quickie:
> >
> > How do I capture the current control the user is on? I've declared a
> > variable "Ctl" and want to save the current control in that variable. The
> > user goes to an input window and when returning, I want to put the cursor
> > back to the control the user was on.
> >
> > TIA
> >
> > --
> > sam
>
>
>