November 14, 2008 at 8:11 am
I have an access form with an identity field that automatically assigns a unique number(NMR_No) when the end-user creates a new record. The NMR_No field on the form shows (NEW) until the user enters data on the form(dirty). I realize that at that time the unique number has been assign and once the form is refreshed it shows the new number. I would like to set this up so that the number is not assigned until the save button has been clicked, rather than on form dirty. Any one have any ideas? I posted this on an access board, but the Identity Column stumped them. Any help will be greatly appreciated.
November 14, 2008 at 8:36 am
I'm guessing since you're posting here that this is an access front end with SQL backend?
why not create a form that when they click new(perhaps it opens a new form or refreshes the current one), it gathers your info in a disconnected way and when they click a save button issue a write to the SQL db. Sort of the same way you'd do it in a web app or something. that allows for them to cancel and that identity record never gets created, which is I'm guessing what you're after here?
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply