pulling in field from another table?

  • Thread starter Thread starter R
  • Start date Start date
R

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?
 
R said:
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?
Click to expand...


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

=DLookup("fldCourseName", "tblCourse")
 
Back
Top