Random Generator

[jbeasley]

I have a Form that I want to put a button on that will randomly pull and answer from a table. Or like roll a die from the choices on a table. Example: Have a button on a form of a six sided dice. When you push the dice button it pulls from a table that has six entries 1 thru 6 giving the dice field of the form a value from the table of 1 to 6. Is this the best way or is there another way to do this? Can someone advise me?
Thanks

 

[pcs]

check access help for the Rnd Function

hth,
al