>Yup, i got it. Thank you so much. But is that any side effect on performance?Is that the best way to achieve it?
>
>#UPDATE
>I only can solve it by public the variable, for the private variable, i facing the same problem.Anywhere i may use public statement, but i have to release all the variable when my form is close.Thank you!!
I don't know why private variables don't work for you. I use them now and then, and they do work for me. OTOH, using a cursor seems an interesting alternative. The global data would go into a single record, which can have up to 254 fields, representing 254 "variables".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)