>My users would like to be able to print bar code labels based off items in their inventory. Each record should generate two (2) lables. How can I go about doing this along with allowing them to automatically add the records that the label is printing from?
If you need the duplicate only for printing, I would save it only once, and create the duplicate in the cursor you use for printing. This can be done in several ways, for instance, a UNION with two identical parts.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)