Is there a way that I can code the db to automatically move to the next field when data has been entered.
Access, like most Windows programs, works off of Events. KeyPress is an event that it understands. The question that we have to ask of you is whether the connection used by the bar code scanner includes a usable event that Windows will recognize. Without a usable event, your answer is probably NO.
Now, you COULD consider this as a way to FORCE an event, but it depends on the reliability of the scanner and a way to know that you have seen the entire bar code.
If you are doing data entry from a form, you can use the GotFocus event of the bar code field to start a timer, then use the Form's OnTimer event to repeated read the code presented by the scanner. If this code is stable over a sequence of some number of scans at least several milliseconds apart (and I'm not talking about several = 2 or 3), the code might be stable. Or, if the scanner won't even PRESENT a code unless it has seen a complete code, you can use that fact.
Compare the code from the scanner vs. the .OldValue of the scan-code field. If they are the same AND the scanner is giving positive feedback of having seen something, you have nothing to store. If they are different, you can store the new value.
In either case, when you are satisified with the current/new contents of the control, sound a beep and do a .SetFocus to the next control.