Setfocus afterupdate event question

[Ktx7ca]

Hello all

I have a textbox(entryID) that when you enter a number the code in the afterupdate event checks to see if it's valid and adds it to a table

At the end of this process I want the cursor to be back in the textbox ready for the next entry.

I have tried several ways and locations of the setfocus command but it never returns to the text box and I don't get any error messages. I can tab to back to the box and of course reclick it with mouse no problem

any ideas why

 

[SoCalAccessPro]

Should be as simple as:

me.entryID.setfocus

Should also be the last line in your code.



Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[Ktx7ca]

Yes I agree with you and thats what I have and it is the last line of code.

you can see why it's driving me crazy

 

[TheAceMan1]

How are ya Ktx7ca . . .

Post the code! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Ktx7ca]

I have removed all the code except for this and it still dosn't work

Private Sub EntryID_AfterUpdate()
Me.EntryID = ""
Me.EntryID.SetFocus
End Sub

 

[Ktx7ca]

It runs the code fine but as soon as I press enter it moves to the next tab order and does not do the set focus.

 

[TheAceMan1]

Ktx7ca . . .

Set focus to another control first, then back to EntryID.

[blue]   Me.EntryID = ""
   Me![purple][B][I]AnyOtherTextboxName[/I][/B][/purple].SetFocus
   Me.EntryID.SetFocus[/blue]

Realize you'll never successfully enter any data with the code you've provided!

[blue]Your Thoughts . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Ktx7ca]

I have tried that a few times and just tried did again, but no luck.

Maybe there's something wrong with the form. I think I'll try creating a new one

It's very strange

Yes I do know that I don't enter any data with the code, this problem is so strange I took it out to make therer was'nt the slighest posability of some conflidt.

But thanks for pointing that out, as you never know

 

[byurow]

You could always put the setfocus code on the Lost Focus or On Exit event. That would, however, create logic that would not allow the user to move to another field. You would need to create an If statement on the LostFocus event that allowed the user to move on if certain criteria were met. For example, if the field is blank and the user is allowed to go another field you could use the following code:

If Not IsNull(Me.EntryID) Then
   Me.EntryID.SetFocus
End If

Brenda

 

[TheAceMan1]

Ktx7ca . . .

I've been thru this before with other events ([blue]On Exit, On Lost Focus[/blue]) and it appears the best thing to do is to let the event ([blue]AfterUpdate[/blue] in this case) complete. I offer the following work around in case you still meet dead ends. [blue]The technique uses the timer to allow the event (AfterUpdate) to complete[/blue] and executes the code you'd normally have in the AfterUpdate event.
[ol][li]In the controls [blue]AfterUpdate[/blue] event, copy/paste the following:

[blue]   Me!Name = Null
   Me.TimerInterval = 10 [green]'Allow AfterUpdate to complete.[/green][/blue]

[/li]
[li]In the forms [blue]On Timer[/blue] event, copy/paste the following:

[blue]   Me!Name.SetFocus
   Me.TimerInterval = 0[/blue]

[/li][/ol]
Do your testing! [thumbsup2)

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886