DMAX Function

[Michael Stengel via AccessMonster.com]

I have the dmax function working properly on assinging the next available
ID number. Problem I have is with multiple users. I need to be able to add
more then one person to an ID so I can not set the "allow Dups" to no. How
do I prevent auser getting the same ID number someone else has already been
assigned using the DMAX function.

 

[Rick Brandt]

I have the dmax function working properly on assinging the next
available ID number. Problem I have is with multiple users. I need to
be able to add more then one person to an ID so I can not set the
"allow Dups" to no. How do I prevent auser getting the same ID number
someone else has already been assigned using the DMAX function.

What event are you using to retrieve the DMax() value? If you use
BeforeUpdate there is little chance that two users woul ever get the same
value. Any other event or trying to use it in the Default Value will give
you this problem.

 

[Michael Stengel via AccessMonster.com]

Do you use the DMAX function in the "beforeupdate" of the form? or the
field? to prevent two users getting dups.

 

[Michael Stengel via AccessMonster.com]

This still allows me to keep the property of the field to allow dups, when
needed?

 

[Rick Brandt]

This still allows me to keep the property of the field to allow dups,
when needed?

I don't understand the question. Allowing or disallowing dups is a
table-level design issue and has nothing to do with any of this.