Update not seen in subsequent query

[Jeff Wilson]

Seeing an odd situation I've not seen before.

Have VB that updates a field in a table based on a form value when a
button is clicked. Directly after the .Update, I call another
function that does some other work and, in the process, queries the
table I just updated for the record I just updated and it does not see
the update I just made.

If I run in the debugger the problem doesn't occur. It seems like the
..Update event is not yet completed before the subsequent query is
executing (running in the debugger slows execution down sufficiently
for the update to complete?)

Is this a feasible explanation? Is there a solution?

The table involved is about 10,000 records.

[Pieter Linden]

Try sticking in a DoEvents between the execution of the update query
and the subsequent select query. Queries execute asynchronously (I
think), so you could be trying to read the updated table before the
update is complete.

[DFS]

"Jeff Wilson" <jw*********@attbi.com> wrote in message
news:fc*************************@posting.google.co m...

Seeing an odd situation I've not seen before.

Have VB that updates a field in a table based on a form value when a
button is clicked. Directly after the .Update, I call another
function that does some other work and, in the process, queries the
table I just updated for the record I just updated and it does not see
the update I just made.
Jeff,

You probably need to issue a Refresh command somewhere to commit the change,
before calling the 2nd function.

If I run in the debugger the problem doesn't occur. It seems like the
.Update event is not yet completed before the subsequent query is
executing (running in the debugger slows execution down sufficiently
for the update to complete?)

Is this a feasible explanation? Is there a solution?

The table involved is about 10,000 records.

[TC]

Are the update and the query both running off the same
dbengine.workspace.database reference?

TC
"Jeff Wilson" <jw*********@attbi.com> wrote in message
news:fc*************************@posting.google.co m...

Seeing an odd situation I've not seen before.

Have VB that updates a field in a table based on a form value when a
button is clicked. Directly after the .Update, I call another
function that does some other work and, in the process, queries the
table I just updated for the record I just updated and it does not see
the update I just made.

If I run in the debugger the problem doesn't occur. It seems like the
.Update event is not yet completed before the subsequent query is
executing (running in the debugger slows execution down sufficiently
for the update to complete?)

Is this a feasible explanation? Is there a solution?

The table involved is about 10,000 records.