Autonumber advancing when opening form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top