.SetFocus ... can't make it work. 1

[gusbrunston]

Hi:

After trapping an invalid entry, I'm trying to return the user to the appropriate control, like this:
[tt]
...
MsgBox msgString, 48, titleString
DoCmd.CancelEvent 'tried omitting this
Me!cboPayerPayee.Undo 'tried omitting this
Me.cboPayerPayee.SetFocus
...[/tt]

However, after closing the msg box the focus goes to the next control in the tab order (tab view).

Appreciate any help with this. Gus Brunston, using Access2000 Intermediate skills.

 

[jebry]

Hi Gus!

In the control's BeforeUpdate event use the following code:

If YourValidation = False Then
MsgBox msgString, 48, titleString
Cancel = -1
End If

This will stop the update and automatically retain the focus in the original control.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[sha76]

I had this one too. Ended up first setting the focus to another control & then to the control I wanted!
ie

Me!cboPayerPayee.Undo
 Me.cboOther.SetFocus
   Me.cboPayerPayee.SetFocus

 

[gusbrunston]

[tt]
Works like a charm! Thanks very much.

Wonder why I can't find answers in those big thick books?

Happy holiday season. Gus Brunston, using Access2000 Intermediate skills.

 

[gusbrunston]

[tt]
Dear Jeff:
My comment was intended for you. Hence, the star.

Dear Sha76:
Thanks for your response to my thread. That looks like a good work around.

Cheers to both of you. Gus Brunston, using Access2000 Intermediate skills.