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.