Dlookup in a form

[Keeperen]

Hello

I'm a newbie, so go easy and overexplain

I have made this DB (attached) where I want to put in a Dlooup command in form. The form is For_T_Aftaleseddel and the field is Faktureret beløb.

Currently my Dlookup command looks like this =DLookUp([SumOfSalgspris];"Fore_tbl_underark_sum_aftaleseddel";[Fore_tbl_underark_sum_aftaleseddel]![Aftaleseddel_ID]=[Id])

I want the sum of the subtabel corresponding to the ID of the tabel T-aftaleseddel.

My problem is that I cannot seem to get this Dlookup right because when I show the formular in dataview the field Faktureret Beløb says #Name?

How do I solve this ?

Thanks in advance.

Regards Keeperen

 

[John Big Booty]

Your DLookup() should look something like;

=DLookUp("SumOfSalgspris";"Fore_tbl_underark_sum_aftaleseddel";"Aftaleseddel_ID = " & [Id])

 

[John Big Booty]

You may also find this link on the subject useful.

 

[Keeperen]

YES YES YES it works! I have tried tried and tried, but no success untill now! Thanks!!!!!!!

Keeperen

 

[boblarson]

YES YES YES it works! I have tried tried and tried, but no success untill now!

Not surprising. We have good people helping here. JBB is one of the best.

 

[John Big Booty]

I'm going to have trouble getting my hat on now