Preventing a control from losing focus

[Daniel Forstner]

I am currently working on a project where I am using a bar code scanner that enables people to scan their employee ID and another bar code from a piece of paper. The scanner scans the code to a text box that has focus. However afterwards the text box loses focus and I can't set the focus to the text box in its lostfocus() event.

Any ideas how to do this?

I am working with Microsoft Access 2003.

Any help would be greatly appreciated.

Regards

Me!

[Daniel Forstner]

Post was not needed, found a solution to the problem that i had previously overlooked

[Daniel Forstner]

For anyone interested I have figured out a solution to this issue.
It's rather simple but i makes my system work :-)

I added an invisible control to the form and made it next in the tab order after my input text box. Under the "On Got Focus" of this control i made it return the focus to my input text box. This way I can still use my other controls while maintaining focus on that text box after someone enters a value into it.

Regards

ME!

[NeoPa]

I wonder if you considered adding your code to the control that was already next in the sequence rather than having to add a new, invisible, control just for that purpose.

Also, have you considered mouse usage? The mouse can click on any control that can take the focus. If you want to disallow this then each such control needs the same code associated with it.

You may also want to consider the .TabStop property of the other controls.