I need a program in Access that should do the following. A barcode pistol is connected to the PC via USB port and is able to act as scanner reading barcode labels. Labels where produced by us and always represents 4-6 numbers. The barcode label converted to number again and then could transfer to an Excel or Access field or every field that has focus. So what I need is an Access form with a field that accepts these numbers, via pistol and if this number matches a number from an underlying query/tabel a subform, that based on this query/table, should pops until another number is selected. All matched data should append to a table for log. Of course focus is always on entry field if the Access form is open.