Keeping Focus 1

[Waynest]

Hi

I have a textbox which is accepting barcode scans. I want the textbox to accept x number of scans before some other code is executed. How do I keep the focus on the text box after it has accepted a scan? I tried using the setfocus method in the text box's afterupdate event but that doesn't seem to work.

 

[JerryDennison]

There is a quirk in Access that prevents you from setting the focus to a control that just lost the focus. You can overcome this by setting the focus to another control on the form then immediately set it back to the original control. Keep in mind. When you set the focus back it may "select" the value that is in the control, if you type or send data it may "overwrite" what was in it. Seems to me a better method would be to treat each scan as a separate field. You can do this with unbound textboxes. Then when all have been filled in concatenate them into a single string and assign this to a bound control.