# MS Access question

**URL:** <https://boards.straightdope.com/t/ms-access-question/216451>\
**Category:** Factual Questions\
**Created:** [December 2, 2003, 5:47am UTC](https://boards.straightdope.com/t/ms-access-question/216451 "2003-12-02T05:47:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![K364](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/k364/32/5_2.png) [@K364](https://boards.straightdope.com/u/K364)\
**Post date:** [December 2, 2003, 5:47am UTC](https://boards.straightdope.com/t/ms-access-question/216451/1 "2003-12-02T05:47:16Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Jpeg\_Jones](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@Jpeg\_Jones](https://boards.straightdope.com/u/Jpeg_Jones)\
**Post date:** [December 2, 2003, 6:18am UTC](https://boards.straightdope.com/t/ms-access-question/216451/2 "2003-12-02T06:18:34Z")

</div>

Make a command button on the form and use the resulting wizard to Record Operations|Duplicate Record.

---

<div class="post-metadata">

**Author:** ![K364](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/k364/32/5_2.png) [@K364](https://boards.straightdope.com/u/K364)\
**Post date:** [December 2, 2003, 8:17pm UTC](https://boards.straightdope.com/t/ms-access-question/216451/3 "2003-12-02T20:17:56Z")

</div>

Thanks JJ, that’s a great answer. Unfortunately, I’m using a tab control and subforms so it won’t be that straightforward.

But, based upon your lead I am looking at two MS Knowledge Base articles that purport to handle the more complex situation.