You don't need any code - sesame has a built-in copy function that'll do it in a second - look in your manual in the section on importing / exporting data. When you get there look at the section on copying records.

Putermann..

Yes - you can do the same things in Designer preview mode that you can do in Runtime - Copying the records is not a "press one button" operation though. You have to have both forms open. The one you're copying from should be in "update" mode and preferably you've already retreived the records you want to copy. Switch to the form you want to copy the records into. In the bottom left window where the element names are listed, look at the top of that window. There's a small arrow on the right. Click on it til the title at the top of the window says "copy to ----" then double click on the name of one of the elements listed in the window. A similar window will open showing the element names from both the open forms. One column will have the "source" element names, the other will have the names form the "destination" form that you'll copy to. Clickon the names (one at a time) in the destination list and drag them to the other window and match them with the correct ones from the source list. If the element names are the same in both forms you can press the "match names" button at the bottom and it'll happen automatically. If you don't want to copy from all the source elements (fields) just don't match them to anything. When your done, press the close button at the bottom. You should be back at you "destination" form. In the element window again, click the small down arrow at the top. One of the selections will say "run". Highlight that and you're done. Everything will be copied as you specified.

Happy Copying
Putermann..

You could use multiple XLookup (or @XLookup) functions, or one @XLookupSourceList, to retrieve the data for each element. And of course, this could be activated with a command button.

I have defined and saved a copy spec, but every time I try to load it through the @loadcopyspec function it always returns as fail, and then I am not sure how to execute it once it has been loaded programmatically.

Not sure what I am doing wrong as I thought this would be fairly straight-forward.  Any code examples/ideas/suggestions would be really helpful.

Thanks.