David,
I think your code is more along the lines of what I am looking for. The problem is that when I try the .column1.controlsource the code errors off because column1.controlsource is not a property or unknown member. Do you have any other suggestions?