Forms DLookup textbox loading slow but query is already open

[MFS]

Hello,
On my main form it shows current production data in textboxes. The code used in the textbox is a DLookup to a Query.


The textboxes are loading the data extremely slow. So I did some investigation by opening just the query and it loads fairly quickly.
Can anyone provide assistance?

[ItsMe]

...a DLookup to a Query.
The textboxes are loading the data extremely slow...

Each Domain Function will take an independent trip to the data. Very slow.

[NTC]

Compared to a query itself; the DLookUp fires later and takes longer. Typically this is not a problem. It is a good way to display information that is not part of the form's record set. Some alternatives are:
* consider a sub form
* if there are multiple dLookups - have them not fire unless a button is pressed to view the data - rather than all fire every time the form opens/becomes current
* make the data part of the form's record set
* be sure the dlookup's source (query) does not have sorting - which slows down the process - and use the smallest possible tables in terms of record count

[MFS]

I ended up using a subform.
Works a lot better.
Thanks for all your help and support