have form field randomly generate number between x - x

[crombiecrunch]

hello all



I have three form fields called Stratum_Port_One, Stratum_Port_Two and Stratum_Port_Three

I would like to set a random value range for these three fields between say 3333 - 26000 each field can not have a duplicate number in that field and then there should be no duplicate numbers between any of the three fields.

If that is not possible then I can just go with an autonumber starting at port_one 3333 increase by 15 for each new record port_two 4333 increase by 15 for each new record and port_three 5333 same increase by 15

ive been searching and cant find a solution that works

[June7]

Generating custom unique identifier and saving to record requires VBA in some event. Common topic on forum. Search on those keywords should return many hits.

[burrina]

Doing a Random number is one thing but creating a counter is another. Here is an example that you could modify to suit your needs, Maybe?
You could use Dmax to advance the number by whatever!


HTH

[June7]

Relying on random generator to produce unique values would be next to impossible. Incrementing a known value by a static factor far easier. Doesn't matter if the increment is 1 or whatever, the code will simply add what it's told to. As burrina suggests, DMax is one way to code.

[crombiecrunch]

thanks for the info folks, I think I got what I need working with

=Nz(DMax("[Stratum_Port_One]", "[Table1]"), 0) + 15

now my next question is I have 37 records in the database already, if i start with record one and the "beginning" port values, is there a way to move to each record and have it refresh with the new code? Or do i have to manually edit each record

[June7]

For only 37 records, I suggest you do it manually and get it done instead of taking time to create and debug code.