I support an application which uses DLookup extensively in ADP code modules.

In the code, a DLookup statement executes, and then a stored procedure
executes a few lines later.

In the profile trace, I found to my surprise that frequently the stored
procedure actually completes BEFORE the DLookup statement, even though the
DLookup statement precedes it in the code.

This shouldn't be asynchronous, should it?  Should not the code execution
wait for the DLookup to complete before proceeding?

This is sometimes a problem, because the action taken after the DLookup
statement is determined by the results of the DLookup statement.

I'm going to get rid of the DLookup statement and see if it is corrected,
but I wonder if this is a common occurrence, and what is the cause of it.

Thanks
Bill