Thanks for answering.I'm trying to avoid using a data control.The first connection to table 1 is through using ADO command.For table 2 I would like to do the same.Thanks again.