Dlookup error $name?

[buffaloguy]

I am struggling with a simple dlookup as a form control source. Here is the setup.


Table :Enroll_gradenames
Fields: grade_name, dgrdisplay_order,
Form: enrollmentsub (This form is a subform of form named enrollment which is on a tab control of a form called teacherresources
Control name on from which has value:enroll_desc

I have tried the following which results in the #Name? error

=DLookUp([Enroll_gradeNames]![dgrdisplay_order],[enroll_gradeNames],"[ [grade_name] ='" & [enroll_desc] & "'")

I have used blookup before with success. Any troubleshooting tips are greatly appreciated.

[orange]

Is this what you are using DLookup??

[buffaloguy]

Senior moment. Yes, it is dlookup. I will edit my post. I have it right in the db. Thanks

[Missinglinq]

I believe you'll find that

[Enroll_gradeNames]![dgrdisplay_order]

should simply be

"dgrdisplay_order"

Linq ;0)>

[buffaloguy]

Same error. Here is the new string.....=DLookUp("dgrdisplay_order",[enroll_gradeNames]," [grade_name] ='" & [enroll_desc] & "'")

[Gicu]

Try =DLookUp("dgrdisplay_order","[enroll_gradeNames]","[grade_name] ='" & [enroll_desc] & "'") (added double quotes around table name)

[Missinglinq]

Gicu is correct...and you really don't need the square brackets around the Field names, since you don't have spaces in them, using the Underscore, instead.

Linq ;0)>

[accesstos]

Give it a try in this way:

=DLookUp("dgrdisplay_order","Enroll_gradeNames","grade_name ='" & [Forms]![teacherresources]![enrollment]![enroll_desc] & "'")

Set correctly the path of the form in which the control "enroll_desc" belongs.

Good luck!

John