Data from Barcode Scanner

[TimTDP]

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

 

[pr2-eugin]

the error message "The text you entered isn't an item in the list......" No error number is provided.

I think the NotInList event would be triggered when this happens, try capturing the Barcode value there and use DLookUp to find the associated ID, and set this ID to the comboBox maybe? (this is just an idea, I have no way of actually experimenting)

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!

I am not 100% sure, but should there not be some event triggering when the Barcode scanner is activated? Maybe catch the details there? (Again sorry my answers are not straight forward, I have not actually used a barcode scanner)