new records not appearing in form - they used to under Access 2

[phil cunningham]

here is my problem

I have a Form that is based on table BOM
In the form I have a button when I press the button I execute the code

....
set mytable = myDb.opentable("BOM")

mytable.Addnew
mytable("Contract name")="Hello world"
mytable.update
mytable.close
DBEngine.idle dbRefreshCache
....

when running this under Access 2 the new record appeared imediately in the
form. But now under Access 97 it does not.
If I open the table BOM the new record is there but it does not appear in
the form.
I can press F9 but they still dont appear
But if I click one of the Sort buttons in the Access toolbar then the new
record appears.
It also appears if I close the form and re-open it

It looks as though Access is not requerying the form even though the table
contents have changed.

Any help will be much appreciated
Phil

 

[Van T. Dinh]

(see answer in original thread)