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