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
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
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
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:
Try this:
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Indeed, that works! I am surprised that Access accept only the function of the language chosen. Thanks!!!
= DLookup( etc...