title: Copying a record in VBA
body: <p>I work with a product that comes in a 2000lb sack and placed on a pallet. When this product is made it has many different elements that are tested and each test has a field that the numerical data is placed in. Each of these records of tests are then assign a number, for example, L20444. </p>
  
  <p>Now we have the ability to take that 2000lb sack and convert it into 80 20lb bags. Only 40 20lb bags can fit on one pallet, taking now the one pallet L20444 and making two pallets that have the number L20444. This causes a problem with inventory because the number L20444 can only be assign one warehouse location, not two. </p>
  
  <p>So my bosses what to create a number that is almost the same, but different enough to place the second pallet in the warehouse. The second pallet will now be L20444B. It will still have all the same tested numbers and is a "copy" of the original L20444.  </p>
  
  <p>My question is can    I take the record L20444 and copy all the data for that record and then save it as L20444B so that it can be placed in the warehouse.  </p>
  
  <p>So is it possible for VBA to copy a record, rename it, and then save it in the same database as a new record?</p>
  
  <p>Any help would be appreciated, Thanks.</p>