Copy and paste a number of records

[gunnie]

I am using access to add new devices received. I enter the description and serial number in unbound fields which adds the new serial number along with the details from the unbound fields to a new record. I also add devices that have no serial number as "Non Serialised". What I want to accomplish is a unbound fields with the number of devices required to add that have no serial number. It will then paste the new record as many times as is entered in the unbound field.

Sorry to ramble on but it is hard for me to explain.

 

[PHV]

In the VBA help have a look at the For ... Next instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244