Delay after an insert using ADO connection

[Bob Ryan]

I find (in my first attempts at using ADO) that I can do
an insert using a connection.execute method successfuly.

If I do this insert and immediatly do a requery on a
subform who's record source is the table into which I
inserted a new row the record source does not include my
newly inserted record.

If I wait a second or two and do another requery my newly
inserted record will show up.

This delay is problematic and I do not understand why it
is there.

Any ideas on how I can avoid it?

Thanks in advance!