Make fields generate random number when button is pressed

[tstowe]

My form has six or so fields that require a Random number to be generated. These generated numbers affect other fields deeper into the form and are working correctly (some thanks to this forum already).

When the form is open I am wanting to have a button that, when pressed, will cause the number fields to regenerate the random numbers and recalculate the other fields that are affected by the new numbers. Once I have the desired numbers in the form, I then want for those numbers to be saved into the database, and unchangeable, for future reference.

This will require more than one incident in order to produce comparisons and other data so I want to create new information on the same form - without change the first, or other, data. Currently, everytime I open the form it changes the data on all records by regenerating the random numbers and the problem is that I don't know how to stop this from occurring.

Currently I have TblNumGen, FrmNumGen and RptNumGen.

Any and all suggestions are welcomed.

Thanks

Tony