command "DLookup"

[Lars-Ove Andersson]

I have problem with the command "DLookup" in Access 2000.
The command takes very long time to run.
Have anybody any solution for this.
//LOA

 

[Dirk Goldgar]

I have problem with the command "DLookup" in Access 2000.
The command takes very long time to run.
Have anybody any solution for this.

Do all DLookup expressions take a long time to run, or only a particular
one? If there's a particular DLookup expression that's taking a long
time, maybe you are looking up data in a query that itself takes a long
time. Or else you may be applying a criterion that is very slow to
evaluate. If it is a particular expression, post the DLookup expression
so we can see what may be wrong with it, and if it's based on a query,
you may want to post the query's SQL, too.

Is your DLookup extracting data from a local table, or an external table
that is only linked to the database the function is running in?