Open MS Access form to new record, but able to edit previous records
<p>I have a button (edit record) that when clicked it will open a form to edit records, which is what I wanted.  Now I've been requested to make that form open to a new record, but also able to edit previous records.</p>

<p>Can this be done?</p>

<p>The reason for this is that users are quick to start typing and they are actually editing the wrong record.  The new record will allow them to search for the right record first.</p>

<p>Or is there another way to do this?</p>