Search results

So the way it is set up is that 4 boxes have to be checked and none of 6 additional boxes can be checked in order to get this unique ID number. If one of the 6 additional boxes are checked than they should NOT get an ID number. If one of the 4 boxes are NOT checked then they will not get an ID...

Also, where is the base place to put this Dmax() function so that the generated ID appears in the form once the checkbox "criteria" are selected. This generated ID will then be used in another web based application to enter deidentified information (aside from ID). The access database is used...

It sounds like I didn't make myself clear. I use an autonumber for my PK, but I do need to create another kind of auto generated ID number that will be assigned only to those that meet some certain criteria true/false. Dmax +1 is exactly what I want, but I want to also define some kind of...

I was going to use autonumber to generate a unique ID number (not primary key), but now I need to generate this number only if some criteria are met. Does anyone have some coding suggestions for doing this? All criteria being use to determine if they should be assigned an ID number are...