pulling in field from another table?

[R]

I want to pull a field into the header of my report from another table, but
can't figure out how.

I have a table called tblCourse that has only one record with details about
my particular program. One of the fields is fldCourseName. I want to pull
this field into my report header. Can I do it without using a query to
bring the two tables of information together - by somehow referring to the
field in the table directly?

 

[Marshall Barton]

I want to pull a field into the header of my report from another table, but
can't figure out how.

I have a table called tblCourse that has only one record with details about
my particular program. One of the fields is fldCourseName. I want to pull
this field into my report header. Can I do it without using a query to
bring the two tables of information together - by somehow referring to the
field in the table directly?

You can just lookup the field by using the DLookup function.
Set the text box's expression to something like:

=DLookup("fldCourseName", "tblCourse")