Scanning a barcode into Access 2003

[GNelson]

My client is a baseball league who started a Kids Club which has membership cards that have a barcode and their own specific number to monitor the number of times that the KidsClub members come to the games. They don’t have any software to go with the cards though. They asked me if I could help. I created a simple table in Access to capture the name, address, telephone, email, number of games attended. The cards have a barcode on them, and they would like to be able to scan the card with a USB handheld scanner and have the number of games attended field to be updated by the scan. Each card has its own number that is programmed into the barcode, which could be the primary key for Access. Can you offer any assistance in how to get the scan of the card to update the "number of games attended" field I created based upon the barcode number?

[GNelson]

There are two things happening that I'm not certain how to fix. I open Access to the form. First, I have a field named "BarCodeID" which the barcode when scanned places the card number in the that field. I need it to bring up the data that corresponds to that card number. For example: Card number 00850 belongs to John Doe, 2525 Data Way, Greenville, SC 29601. So, when the card is scanned in, I would like the data that corresponds to the card number to come up. Right now it's over writing the card number that is currently in the field when Access is opened up.

Second issue. When the card is scanned and the appropriate data that corresponds to the card comes up, I would like the field called, "Number Of Games Attended" to increase by 1 each time the card is scanned.

Can you help?