I tried your suggestion on private variable and it didn't make a difference, however Sergey Berezniker suggested that my database may no be open. I tried it and sure enough it seemed to cooperate. The only problem was my index, I don't know if I can create an index on a view, but thanks for all your help.

Nick Patel

>>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
>...
>* or:
>use MyView alias var_Table
>

>
>Otherwise, you could also centralize the ControlSource setting with OOP inheritance.
>
>HTH, Hilmar.