Alternatives to DMax when generating custom autonumber

  • Thread starter Thread starter Mark
  • Start date Start date
M

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