When I pack the table so I can use reccount(), the grid goes blank.
That is because PACKing the grid's RecordSource closes it, ripping it out from under the grid, causing the grid to have a nervous breakdown. For an explanation and a solution, see Andy's blog entry at http://weblogs.foxite.com/andykramek/archive/2005/03/19/174.aspx