dbgrid and ?rowcount?

Hi all!

    I have a dbgrid for a detail table that relates to a header table by the
HdrID. (Using Access)

    No problem with inserts, deletes, etc by using a navigator.  However, I
want to calculate the total for one of the columns in the dbgrid, and find
that unless I save the record by moving up or down, the total does not
correctly calculate by using an SQL statement that retrieves all records
from the detail table.

    Is there someway I can navigate through the dbgrid without having to
save the record first and use the SQL statement?