Assuming the text box is named EnterCourseNum and the field in the table is
named CourseNum, you need:

=DLookup("[Title]","[ Course Listing]","[CourseNum] = " & Me!EnterCourseNum)

Steve


"vanmen" wrote in message
...
I've been trying to get dlookup to work without success.

I'm trying to get a title of a class to be inserted depending on the
number
of the class.

I tried =DLookup("[Title]","[ Course Listing]","[Course #])

and I get "invalid syntax" message. Can anyone help? Thanks.