Q: When I update an rdo recordsource, the new row doesn't appear unless I
Close and then recreate the recordsource.  I believe it has someting to do
with cursors but have no idea what to do to make this more dynamic.  I am
using SQLServer by the way.

        -brian

I've had this problem when adding a new record to a resultset. I've tried
all kinds of cursors without any success. The only way is to requery the
resultset after an update.

sashi

You should always requery after an add to get the resultset back into
order.

Doug
--
Doug Gibbard,
Lincoln England