See if File > Options > Client Settings > Move After Enter does what you want. It should move to the next record in the same field but I do believe that will propagate to all db's.
Otherwise I think you're looking at a code solution, which will only work for one form. This is about a form, isn't it?
EDIT - OK, could be for more than one form, but each would have to call a procedure in a standard module. Plus the suggestion I made would only be for continuous or datasheet forms, which I figured you are asking about.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.