I'm not sure what you mean by "change a random number that will generate a
random 6 digit number". However, you can use the Rnd function to generate a
random number. Why change a random number? Even if you do, how do you see
that generating another random number.
You can use the Rnd function to generate a random number. It will generate
a decimal, but you can multiply it by 1000000 to get the desired 6-digit
result (with the Format function to add leading zeros, as needed), and use
the Int function to get just the integer portion of the number. One way is
to use the form's Current event, or a command button, with something like
the following:
Me.SomeTextBox = Format(Int(Rnd()*1000000),"000000")
If you want to store the number, bind the text box to a number field in the
form's Record Source, and generate the number only for new records:
If Me.NewRecord Then
Me.SomeField = Format(Int(Rnd()*1000000),"000000")
End If
If this doesn't answer the question you need to be more specific about what
you are trying to do.
