Hi all. First post. Thanks for all the useful info here.
Due to the type of the work my users do, they regularly enter new records that are more or less the same as old ones. To help facilitate this, I'd like to design a form that asks them to enter a record ID number to call the old record they want to copy, then they could hit an "OK" button and have the DB automatically copy the called record to a new record. I'd like the new record to appear in the standard entry form I long ago designed so they can edit the few fields that need editing. Make sense? Any ideas on the best, cleanest and easiest way to do this?
Thanks!