Auto fill after barcode scan

[Magnus1982]

Hi,

I almost finish my form but now i am struggle with big problem .
I will show all process :
1. Scan bar code to serial number field
2. Fill data
3. Fill output
4. Fill power
after 24 hours
1. Scan the same barcode to other serial number field
2. Fill verification output
And finish.

All that in the form .For data I have one table with a lot of columns. Now on the right site of my screen in the same form.Basically points 1,2,3,4 I am doing in Monday. In Tuesday I want to do verification that's why I need scan the same label and find automatically for example output for this product .It is like In warehouse I am scanning barcode and on the screen I have all information about the product

 

[Uncle Gizmo]

The barcode scanner part is a bit of a red herring. All a barcode scanner does, is place a set of characters in A textbox. Then it presses the enter key automatically - so to speak. In other words if you manually type the following numbers into a text box 57832567 and then press the enter key, that's basically all the barcode scanner will do. Now we've got the red herring out of the way, all you need do is key the data into your textbox and then press enter key. The enter key will trigger the textbox after update event. (The barcode Scanner will trigger the textbox after update event in the same manner) Put the code that you want to operate on the digits you have placed in the text box in the after update event. You could use them in a query to find a particular record for example, and then open another form to display it.

 

[HiTechCoach]

Cross posted HERE