Requery without losing focus?

[Axeia]

I have a form with an unbound textbox and to this textbox I've added some VBA code that requeries the form on change. This way the user can quickly find what they're after.

There is one little problem with this, the requery on the form makes the textbox lose focus, the focus is placed on the first bound textbox of the form. I tried working around this by calling setFocus on the unbound textbox, but this also selects all text in it! So if you're typing you keep overwriting what you previously typed.

Screenshot shows the code and form.

[pbaldy]

Check out SelStart in VBA help.

[Axeia]

Not sure what you meant with "VBA help" (No sticky or subforum by that name) but SelStart does the trick.

    Me.tbTitel.SetFocus
    Me.tbTitel.SelStart = Len(Me.tbTitel)

Thank you.

[pbaldy]

Happy to help. "VBA help" means the help system in the VBA editor.