Barbara,
We have gotten the sql code to work ok but when we issue grid1.recordsource="hftemp" all of the formating and the column widths of the grid are reset to the default in the table. We tried to use the grid1.columns(1).controlsource="hftemp.rn" with no luck. It sayed "member columns not found".

Please Help

~Quinn