I have a grades database for an English teacher at a community college. I have an unbound form where I want to automatically insert values based on a value on another form.
I have prepared a little web page which displays all my relationships at http://www.rghollenbeck.com/grades_web/. I have also uploaded an image of the relationships to this post. I hope it works.
My basic problem is that I created an unbound textbox and inserted the source as:
Code:="SELECT tblCourses.CourseDescription FROM tblCourses WHERE tblCourses.CourseCode='" & [Forms]![frmSelectCourse].[cboSelectCourse]"' & ";"
But that generates an error:
I am attempting to display the course description in that text box.Code:The expression you entered contains invalid syntax. You may have entered an operand without an operator."