Autonumber advancing when opening form

[Guest]

I hope I can explain this.

I have a form that has fields updated using a combo box. On the form, I
have ID as an autonumber. When I click to create a new record, blank form
opens at it should, but the ID has already advanced. I want it to stay (NEW)
until I start entering data. Unless I press ESC before exiting the form, the
blank record will be saved.

When a new blank form is opened, I have a couple of macros that reset fields
in option groups on the form. I also reset the value in the combo box to
blank by requerying the combo box.

Any ideas on how to keep this from happening?
Thanks all

 

[Guest]

I think the only way to do this is to unbind your form and save the record in
the close event or some other events.

Barry

 

[Guest]

Thanks for the response. I've streamlined my form a bit more and worked out
the kinks.