Autonumber incriments without save

P

Paul B.

Hello all....

I am opening a form for date entry with the following:

DoCmd.OpenForm "FormName", DataMode:=acFormAdd
Forms!FormName.ContactID = Me.ContactID

This is okay except when I close the form without saving with:

Me.Undo
DoCmd.Close


The table still uses up a number in the RequestID field.

Is there some way to prevent this? More curious than concerned.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vbOkCancel 4
Form closing unexpectedly without error 4
cancel button to undo data entry 1
datasheet view 2007 without saving column layout changes 2
Autonumbering and cancel command 2
Passing values to another form WITHOUT opening it? 5
Need X to act like my "Close without Save" button. 5
Save a single form's record 0

Top