is my code being skipped???????

[Ecniv]

There is a caching problem/issue with dao.

When you update the db it is not immediately updated (I found a link somewhere about this I'll see if I can redig it up and post you a link.

Essentially you need to flush the cache of the db once you've closed the recordset you've updated. Then the db and anything looking at it should pull the right data.

Edit:
One thread
Try searching under JRO and CacheRefresh (or RefreshCache)
If you are using DAO its in the dbengine or application (I think) Or was there somewhere. I used it with a DAO connection to access 97 from vb5. I had the same problem that the record data was in the tables but wasn't getting there before the program queried the table.
I'll see about other links...
KB MSDN link, More MS stuff

JRO looks like the only way to go. Could've sworn there was another way.
>>> DBEngine.Idle dbRefreshCache <<<
DAO (heheh) and possibly the Access Application - forces the db to finish stuff off