Combo box + Barcode Scanner

[Ben171]

Hi all, i have a userform in excel which i want to use a barcode scanner to enter data so that there are no errors.

For textboxes, the barcode scanner works fine. However in a combo box that I have, the barcode scanner enters the correct text but then instantly wipes it out

Is there anything i can do to stop this?

 

[NoSparks]

More than likely, yes.
Can you post the code associated with the combo box?

 

[Ben171]

More than likely, yes.
Can you post the code associated with the combo box?

Hi sure,

My code for this combo box is very simple

Sub cmboProduct_AfterUpdate()
    ' Find the record that matches the control.
    Me.RecordsetClone.FindFirst "[product] = '" & Me![cmboProduct] & "'"
    Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

 

[NoSparks]

Don't see anything there that would clear the combo.
Presumably the same code in a textbox_AfterUpdate event is working as expected but isn't for this combobox.

Try putting a breakpoint on the first line of this code and run the code with the F8 key one line at a time from there when the vba window opens watching for what line of code is the cause of the combo clearing. Execute the End Sub with F8 also and the next code to run will still be in one line at time mode.

The Windows key + right arrow will put the vba window on the right half of your screen so you can see the sheet/userform on the other half.

Sorry, that didn't answer your question but hope it's of some use.

 

[Ben171]

Don't see anything there that would clear the combo.
Presumably the same code in a textbox_AfterUpdate event is working as expected but isn't for this combobox.

Try putting a breakpoint on the first line of this code and run the code with the F8 key one line at a time from there when the vba window opens watching for what line of code is the cause of the combo clearing. Execute the End Sub with F8 also and the next code to run will still be in one line at time mode.

The Windows key + right arrow will put the vba window on the right half of your screen so you can see the sheet/userform on the other half.

Sorry, that didn't answer your question but hope it's of some use.

Thanks for your help that is a very good idea. I have solved the issue (sort of)

I have instead configured the barcode scanner to not press enter after scanning. Doing so makes this work fine with the combo box, only problem is user has to manually press enter but that is not the end of the world.

Thanks

 

[KOKOSEK]

only problem is user has to manually press enter but that is not the end of the world.

Maybe you can use SendKeys("{Enter}"), True instead.

 

[Ben171]

Maybe you can use SendKeys("{Enter}"), True instead.

I'll give this a try, thanks for the suggestion!