Custom DLookup() Function

[Prathmesh]

Hi All,
Recently I read that when a database is split, it would make sense to avoid domain aggregate functions as much as possible since they slow the performance of reports and forms. I have a similar condition in my database, which is split into FE and BE and I am using a lot of DLookup() functions. After reading the suggestion, I tried to replace the DLookup() function in the control source of text box on report with the query "Select fieldname from table/queryname where condition=somecondition". But on the report the field turns out to be "#Name?". I guess there is much more to it that just a simple query. I am not so much good at VBA. Can anybody help me on tips to write the custom DLookup() function? Based on that, I will also try to write custom functions for DCount() and DSum(). But first I want to get the concepts cleared about the DLookup() custom functions.

Many thanks to all in advance for their replies and suggestions.

Kind Regards:
Prathmesh

 

[PHV]

Take a look at RecordSet in your object browser and help files.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

Hi!

Take a look at Domain Aggregate Functions Replacements, ready to use. Or if applicable, try including the lookup tables in the recordsource of the report.

Roy-Vidar

 

[Prathmesh]

Thanks Roy and PHV. The link is excellent.

Regards.