thanks a lot bob.its so useful for me but i have another problem now!
I try to use an variable value in the where condition .i try this command : ...,"[TextFieldNameInTable] = ' "& var1 &" ' and [NumberFieldNameInTable] = ' "& var2 & " ' "
and its not work. could u help me to fix it ?