Requery does not work for the first added record!

Hello,

My main form contains a subform, displaying as spreadsheet a few fields from a table.
I add a new record to that table using a pop-up form and then requery the subform to
update the spreadsheet.

This scenario works fine, but it does not update the subform for the first added record.
If I already have 10 records in the table and trying to add 11th, 12th, and 13th,
nothing happens when I add 11, but updates normally starting 12.

When I set a breakpoint on requery of a subform and after getting control on that
statement immediately run further, the update of 10th record works fine.

I watch this strange effect either for adding new record using AddNew and Update methods
of a recordset, or using connect.Execute "INSERT INTO...".

This really prevents me from getting the job done. Please help!

Thank you.

- Alexey

I experience a very similar behavior and I have been trying to debug this problem for days!

I now suspect a delay in updating the underlying table after the Update command.
It reacts as if there was a buffer containing last entrie(s) and this buffer would dump
to really update the table only once it's full. This would explain the fact that the
requery works after you have entered the 12th and 13th transactions, then showing
11th ,12th and 13th trans.

I'm still in very thick hase!!! Any help would be appreciated

Michel