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
 
Top