Subform - Go to next record on enter

[Pickboy]

Hi,


First sorry for my bad english it is not my first language.
I'm trying to build a simple order form to add product to some order.
I use a subform with a combo box to select the product ID and add it to the order.
If added manually everything is perfectly working.
The trick is that I want to use a scanner to build future order.
What our scanner does is simply type the Product ID and hit enter.
So what I want to do is to be able to set my "Product ID" combo box to go to the next "product ID" combo box when pressing enter and then add new record while scannnig multiple product.
Here a capture of what i'm trying to do.

Thanks for your help on that one.

[June7]

You can lock the other controls and set their TabStop property to No except for quantity. Enter quantity first. Set TabOrder property so the scan field is last.

[Pickboy]

Thanks June7 that perfectly made it you make my day !