Issue with Dlookup- Help Please! (1 Viewer)

June7

AWF VIP
Local time
Today, 00:28
Joined
Mar 9, 2014
Messages
5,472
If instructor expects use of DLookup() then go with it but domain aggregate functions can cause slow performance in query and on forms with large dataset. Referencing combobox column is better - combobox RowSource has already queried the data, DLookup() is a second query for same data.

As for DCount(), probably stuck with having to use.
 

Users who are viewing this thread

Top Bottom