On a form I have a combo box that allows the user to select a record. In addition to the combo box, which I want to keep, I want to introduce the use of a bar code scanner to select the record.
I have added the field "Barcode" to the table.
The combo box is bound to column 1 (productId)
If the combo has the focus, and the user scans a bar code, the error message "The text you entered isn't an item in the list......" No error number is provided.
What is the best method to adopt to convert the bar code to a valid entry in the combo box?
Secondly...
When the user scans a bar code, how can I ensure that a new record is created?
I will not know what field has the focus!
Thanks in advance
I have added the field "Barcode" to the table.
The combo box is bound to column 1 (productId)
If the combo has the focus, and the user scans a bar code, the error message "The text you entered isn't an item in the list......" No error number is provided.
What is the best method to adopt to convert the bar code to a valid entry in the combo box?
Secondly...
When the user scans a bar code, how can I ensure that a new record is created?
I will not know what field has the focus!
Thanks in advance