Send to last textbox that had focus

[rs2k]

Hi,

I have built a form for time sheet entry and part of this form has a custom time-picker, the user clicks a button for the hour and then a button for the minute, this is then combined into a textbox. There are 2 buttons 'confirm' and 'cancel' when confirm is clicked I need to send the time to the last selected textbox (time entry) that had focus, the time entry textboxes are on a continuous subform. But as soon as a time is picked the focus has changed.

Is there a way around this?

Many thanks


Colin

This has also been posted on another forum.

[ItsMe]

Nothing is impossible but, without storing data in an additional table(s) to track the movement of the cursor, the answer is no.

[rs2k]

Ok, thank you. I wont waste any more time with this then.

Cheers
Colin

[ItsMe]

On second thought, I suppose a single variable declared in the VBA header could store the control name.

Use code in each possible control's On Enter event handler.

strLastFocus = "Hard Coded Text Here that is the name of the control"

[Missinglinq]

I'm not really clear as to what you're describing, but there is a command

Screen.PreviousControl

that may do what you need.

Linq ;0)>

[rs2k]

Hi, sorry been away for a week. I will try out your suggestions and post back.

Cheers
Colin