Runtime Data Controls

[boyinthefire]

to make a long story short ,
i want to be able to set all my data control and data bound controls at run time;

Command1_click()
text1.datafield = "blah"
end sub
will work but
command1_click()
data1.recordsource = "sheet2$"
will not access the data plus the data control itself locks up



I have tried many different ways of trying this and am fried, any ideas, my project is due soon.

[boyinthefire]

in case anyone else was having that problem , I figured out that the answer is to use a DBgrid object