bookmark control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smk23 - 05 Mar 2005 21:35 GMT

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

Signature

sam

Reply to this Message

Douglas J. Steele - 05 Mar 2005 22:33 GMT

Screen.ActiveControl.

Signature

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

> This should be a quickie:
>
[quoted text clipped - 4 lines]
>
> TIA

Reply to this Message

smk23 - 05 Mar 2005 22:49 GMT

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.

> Screen.ActiveControl.
>
[quoted text clipped - 6 lines]
> >
> > TIA

Reply to this Message