>Is it possible to use setall command to set controlsource property of textboxes on screen? If so, how can I associated lets say a textbox controlsource property where the view is dyanamic. For example my textbox controsource property needs to be dynamic in that it can be lv_offdsp1.text1, lv_offdsp2.text1, or lv_offdsp3.text1. I need to use setall command with (view).text1
>
>Thanks
>Nick Patel
.SetAll() sets all controls to the
same value - the ControlSources have to be different.
When I need something similar, I just open a table or view (the same form might open once with a table, once with a view) with an alias:
use MyTable alias var_Table
...
use MyView alias var_Table
Otherwise, you could also centralize the ControlSource setting with OOP inheritance.
HTH, Hilmar.
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)