>John, is the 2ndtable being used in the grid as well. Also, it's fine what Edward recommended but when you have to reset the grid you lose your column headings and ControlSource as well. It really depends what you are doing on the 2ndtable. Give us more info.
Sorry, you don't lose headings etc. if you take more steps. As you correctly say, it all depends on interface requirements.
Edward Pikman
Independent Consultant