I have set up a basic Access 2000 database for our company for recording serial numbers of the products that we sell. We record what product was sold, who it was sold to, etc. We also create a record for each repair done to a unit when it is returned for repairs.
Many times we sell 50 to 100 of one product to the same client with a sequential range of serial numbers. Currently, I have to enter a separate record for each serial number individually, when all the information for the group of units is the same (except for serial number). Is there a way I can enter multiple records at the same time, for a range of serial numbers? I realize this would probably take some VBA programming, which I am not terribly familiar with, so if your solution involves VBA, please include as much detail as possible. Thanks.