0

I have a query named "TeacherDistributions" includes the following : 

 TeachertorName          Subject             Class

and I use the code below to retrieve the teacher name according to value of two text boxes. However, it retrieves no teacher name. Am I mistaken in my code please ? 

=DLookUp("[TeachertorName]","[TeacherDistributions]","[Subject]='" &  
[txtSubject] & "' AND [Class]='" & [txtClass] & "'")
FSm
  • 2,017
  • 7
  • 29
  • 55

1 Answers1

1

The code is correct, so either you feed the wrong values as parameters or a record for those parameters doesn't exist.

Gustav
  • 53,498
  • 7
  • 29
  • 55