VB Function repeatedly called
Posted on 2006-04-26
I have a VB function which is called to generate a psuedo-random number for a particular field in a query. This works okay, except for that whenever the field is scrolled out of view, or the query result window resized, the values change. I can't check if a value is already in the field as this causes a cyclic references.
Can someone suggest a way for the VBA function to be called once and only once (or at least not update the query field)