Alternatives to DMax when generating custom autonumber

[Mark]

I have been using a DMax statement in the BeforeUpdate event of a form.
This gives the user an order number with no gaps which they can use. The
problem is that on a couple of occaisions this method has produced duplicate
order numbers. The only way that I think this could have happened is if two
users raise an order at exactly the same - is this correct? Are there any
more reliable alternatives to this method which I should be looking at?

Thanks

Mark

 

[BruceM]

One possibility is covered here (watch for line wrapping in the address):
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb
Roger's example uses the default value of a bound text box, but the
principle is adaptable to using VBA to assign the number.