Access Macro Project

I have an MS Access 2007 form with a sub-form. I would like a macro button that when pressed it will add fields into the sub-form from another table.