Here, upperbound is the highest number in the range, and lowerbound is the lowest number in the range.
To repeat sequences of random numbers, call Rnd with a negative argument immediately before using Randomize with a numeric argument. Using Randomize with the same value for number does not repeat the previous sequence.
In this example we won't pass a value.
The result is a random number.
The results using a Query would be
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtRnd", then you could add the following in the Load Event.