Sometimes I get a message that it has to be a variable when I set thisform.field.controlsource = a.field, but not always. Also, I can't get it to thisform.refresh after I make the switch.

Thanks