I have written an app with views based on access queries. When I want to do
an update I update the RS object based on the table that has the data item
to be updated. Then I do a requery on the RS based on the view (containing
the changed item), but the view does not reflect the new value. I have also
tried closing and re-opening the table based RS prior to requerying the view
and also closing and reopening the RS based on the query as well. I have
tried snapshot and dynaset versions with no luck.

My updates are working, I can see my changes if I close and re-open the
application.

Has anyone tried this before? Is there some secret to flushing recordsets?

Thanks,
Mike