OK... This is a new question that references to a previous post
. Currently I have a form with a text field that has the "default value" as =Nz(DMax("RepairNumber","d
)+1 which increments the "default value" set on the the RepairNumber field of the table used as the record source for the form, and it works just fine, however now it will be used in as multi-user application and from what I read on some of the post here and elsewhere, that could be an issue. I was also reading some suggestion that recommend I use another table to generate the unique number and retrieve it from that table similar to what Dale Fye mentioned on that post. But I am not sure how to generate that table value and retrieve the unique value for each record.