Problem with assignimg default value to text box when entering new record

[ezybusy]

I mean the Id doesn't followin a professional manner.
For instance if we cancel entry 1000 times, then the next completed entry get an Id of 1001.


That's what I mean by gaps.
So you can imagine if we have to cancel entry 10000 times.

But anyway so far that's the ideal solution for now. I will still try to figure out other ways to make it work. If not I will have to stick to your suggestion.

[ssanfu]

That is the way an autonumber field works. Once a number is used (whether or not you keep the record), it is never reused.

I just had a discussion with PBaldy on this subject.



See these sites:

Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers


Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp

[June7]

There are ways to manage cancelling record when autonumber field is involved and not leave 'blank' record but not simple for all the reasons already presented. Need to tightly control user interaction and sounds like you have code in place to accomplish. However, there will be gaps in the autonumber sequence (as you have already noted) but that should not be a concern.