Good Morning,

I have been requested to add a "copy" functionality to an app. Basically, the user should be able to locate the correct record, press a cmdButton and have a duplicate of the current record added and presented for slight modification.

I have no trouble getting them to the record to be copied. I'm not sure how to copy the record and make sure that I end up on the copy.

My inital thought is....lock the screen (so the user doesn't see any change or movement on the input form), copy each field from the current record to a cursor, append a blank, move to the appended record, paste the fields, and then unlock the screen so the user can make the change, or cancel.

Ideas from those who have BTDT would be greatly appreciated.

TIA,