>I would like to understand why, when I run code from a click event of a grid cell to fire a Select Statement and a Report Command, the report will not retain the data from the Select Statement, but reverts to the table data defining the grid. If I use an other control to fire the Select Statement and a Report Command, which causes the grid to loose control, everything works fine. Just tring to understand why, would like to reduce mouse clicks.

See Forms with Grids and printing reports FAQ #15515