I have the following “classic” setup…
A form that has a record source of a table and all bound controls. The table has an autonumber field for a key.
My problem is that I want to allow the user to do a “Save As”, i.e. leave the original record untouched and create a new one.
Correct me if I’m wrong (please!), but this doesn’t seem to be very easy in Access.