Update on entry

[alsu50]

Hi All,

I have the table of books' barcode values and a barcode reader. I would
like to keep my inventory in electronic way using an Access Form.

I would like the form to look up the rest of the book info (from the
Access table) once the barcode is entered for the current record.

What should I use? What kind of event? Is it even possible to do for
the current (active, selected) record. My barcode scanner sends "Enter"
command after the barcode scan.

Thank you!

 

[Duncan Bachen]

Hi All,

I have the table of books' barcode values and a barcode reader. I would
like to keep my inventory in electronic way using an Access Form.

I would like the form to look up the rest of the book info (from the
Access table) once the barcode is entered for the current record.

What should I use? What kind of event? Is it even possible to do for
the current (active, selected) record. My barcode scanner sends "Enter"
command after the barcode scan.

Thank you!

What you can do is to have an unbound textbox which you would scan the
barcode into.

Then you can use the after update event to trigger the lookup of the
record based on the barcode. The enter key will trigger the after update
event because it will accept the entry.

Alternately, you could use the keyup event, and check if the keycode
equals the Enter key. Though that would fire once for every character of
the barcode being scanned, which is why I suggested the other way first.

 

[alsu50]

I will try that. Thank you!