DLOOKUP vs FIND For Values as Field names

[BobM]

i read the thread entitled "Convert Field Value String to Actual Field in Expression"

It appeared that the final solutions got moore complex not less complex

MY PROBLEM IS:
1. get a value from one table as a string "C"
2. lookup the value of a field in a TABLE2 "CD"
where the field name = the value of field in TABLE1

I CAN GET THIS USING DLOOkUP, BUT NOT BY FIND METHOD
example:
TABLE1 - 3 FIELDS (50 parts, 1 code and 1 item per part)
(part as string)+(code as string,3) + (item as string, 255)
99 choices for code are (HD01->HD99)
ex: c = value from TABLE1 (if [PART] - "AN" then c = "HD05")

TABLE2 - 100 FIELDS (1 ID, 99 dates) FOR SPECIFIC PERSON
(ID as long) + (HD01) .. (HD99)

ex CD = DLookup("" & C & "", "", "ID = " & PATID)
(find record using findfirst and get value from field "HD05")
Returns CD = #02/03/2006#

I am under impression that using DLOOKUP is slower than using the FIND Method.
If so, what I want is:

TABLE2.FINDFIRST ("ID = " & PATID)
C= "TABLE2" & C
RETURNS "C = TABLE2!HD05"
CD = C
CD = #02/03/2006#

What I get is
CD = "TABLE2!HD05 "



Any Ideas?

[PEB]

Hi
It's like a double post, but the content is different from your previous one...

And the question is more clear!

Definitely the Dagregate functions are the worst thing you can use! They lock your tables seek poorly and in network environnement are really poor...

If you use them in Append query for exemple and you do a sum of the previous values of the introduced till the current record records it will be faulty! It will be faulty either if you don't use transactions!

Those functions can create only problems in multiuser environnement!
:)