[Help] SetFocus method

[Alias90]

Hi Everybody!

Maybe this is stupid question.'Cause i am newbie in Access.
I had a problem with setfocus method.In textbox_AfterUpdate Event(txtkanban_AfterUpdate), i coded :

Me.txtkanban=""
Me.txtkanban.SetFocus

However, the cursor removed to the another commandButton(cmdEdit)
in design form, tab order i chosen :
1.txtkanban
2.txttong
3.cmdEdit

Thank U in Advance

[twinnyfo]

Alias90,

I am unable to duplicate your results.... Are you sure that the TabStop property for txttong and cmdEdit are set to yes? This could be your problem....

[Alias90]

twinnnyfo!!! Thank u so much
I'm sorry.Yes, i had mistake. I have chosen 1.txtkanban 2.cmdEdit 3.txttong. But when i chose again 1.txtkanban 2.txttong 3.cmdEdit . the cursor move to txttong. So my purpose is cursor move to txtkanban again. So i don't know to sovle it now. Somebody help me,pleaze!

[twinnyfo]

Alias90,

Hmmmmmmmm. Part of me wonders why you would have code like this, to enter a value into a text box, then simply clear it out after you enter it? I can speak with certainty, but it appears that once you update a control, you can't simply reset the focus to it, you must set it elsewhere first. This would not be the first quirky aspect of Access.

I know a workaround is to set the focus to another control, then set it back to the original control. Which works, but from a programmer's standpoint, is mindless....

If the only goal in this is to clear the contents of txtkanban and set the focus to that control, this will work, but still unsure of the purpose.

See below:

Option Compare Database
Option Explicit
 
Private Sub txtkanban_AfterUpdate()
    Me.txtkanban = ""
    Me.txttong.SetFocus
    Me.txtkanban.SetFocus
End Sub
 

Hope this solves your problem.....