Cause a RND function to reevaluate

[timmygrover]

What property of a field in a form that generates a random number would need to be modified to cause the RND() to reevaluate every time you tabbed to a new field in the form? Or maybe it could be linked to a button or something? I'm just not sure what the language would be to trigger a reevaluation on a certain action.

[June7]

Why do you need a random number? What are you really trying to accomplish?

The form is bound to table or query? Is the RND() function in query or textbox ControlSource?

[timmygrover]

Why do you need a random number? What are you really trying to accomplish?

The form is bound to table or query? Is the RND() function in query or textbox ControlSource?

This is in an unbound form, I've got text that is randomly generated though a series of iif statements that are dependent on random numbers that are generated through RND() functions. I want the user to be able to update the values of the RND() functions so that they can get multiple versions of the text.

[June7]

One way might be code in the GotFocus or LostFocus event of each control to refresh the form:

Me.Refresh