Hello,
    I have a form class module that uses the doCmd.RunSQL statement.
The first two work, but immediatly following in a call to another
subroutine I have a disconnected recordset that is updated with new
records and finally a rsSummary.UpdateBatch statement.  The new
records are put in the table, but when I return from the subroutine,
the Me.recordsouce = "qrySummary" statement which gets run, doesn't
show the new records.  Only when I exit 'that' form and come back are
they there.  I checked, and they are also in the table everytime.  How
can I show the updated records in the table without exiting the form.
I tried Me.refresh, Me.repaint, but maybe I'm using it wrong somehow.
I think I close the recordset and connection too correctly by
'myconnection.close' and 'Set rsSummary = nothing'.  Also, I stepped
over the add record subroutine, and when It's not called the
doCmd.RunSQL statement that followed worked properly but of course
there were no new records to add; only the records I put in there to
test it.  The RunSQL statement is a append query that append the new
updatedbatch table to another table that will be queried to
(hopefully) show the records.
Thanks for reading and helping.
Gary