I have a sbfTests with testing information. One of the text boxes has NRSLevelID, and I need to look up the corresponding text value EducationFuncLevel in the tblNRS (because this subform is also used for data entry, I cannot pull the text values into the query qryTestingUpdateable underlying the form because then the query won't be updateable).
The DLookup in the text box on sbfTests is
=DLookup("[EducationalFuncLevel]","tblNRS","[NRSLevelID] =" & [Forms]![sbfTests]![NRSLevelID])
When I look at the subform by itself, the appropriate text values EducationFuncLevel display fine. When I look at the subform on its main form, though, instead of the text value, the field says "#Name?"
Why?
The DLookup in the text box on sbfTests is
=DLookup("[EducationalFuncLevel]","tblNRS","[NRSLevelID] =" & [Forms]![sbfTests]![NRSLevelID])
When I look at the subform by itself, the appropriate text values EducationFuncLevel display fine. When I look at the subform on its main form, though, instead of the text value, the field says "#Name?"
Why?