Link to home
Start Free TrialLog in
Avatar of Noero
Noero

asked on

DLookup #NAME problem

Hello,

with clue of a previous experts exchange guy, I noticed  that I had to use a Dlookup function for the purpose I assigned myself:
In a formular, frmCourseMain, I just want to add a textbox (SUM in red in the file) which contains the sum of the fees of the student registered for the course chosen.

nevertheless, even if I read tutorial  on it, I still have a #name problem on the textbox names Sum
So, maybe you should fix it, again!
Thanks in advance!
example.mdb
Avatar of mbizup
mbizup
Flag of Kazakhstan image

You need an "=" sign before the DLookup in the control source:

= DLookup( etc...
Avatar of Noero
Noero

ASKER

Thank you but that doesn't seem to work (use a combination of space thereafter).
May be it's because I am using a french version of Access 2000
capture1.bmp
capture2.bmp
It shouldn't make a difference...

Try this:

ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Noero

ASKER

Indeed, that works! I am surprised that Access accept only the function of the language chosen. Thanks!!!