We have a form that is a series of detail records that enters in
Line Number - Product Code - Product Description - Weight - Lot Number
We have been back and forth with users who try to enter in the columns all at once. SO users have entered in all Product Codes in a tall stack and the Weights all at once in a columnar format. We have had the users have some success with entering it in that way but we have also had some problems with errors and codes that come back forcing the user to delete the entire record and start over. We have had much less of a problem with the users filling the records out left to right ....row by row.
Is there a way to make that part of a form allow us to build that part of a form more like filling a series of columns in a spreadsheet from top to bottom or is Access forms really not designed to do that.......?