Populate Text Box from different source

[Diane]

Report is generated by a query. I would like one of the text boxes to
populate the Name of Department corresponding to the Department No from a
different source (TblDepartments) instead of the query. I tried to use the
Dlookup as follows:
=DLookUp("[Name of Department]","[TblDepartments]","[Department
No]=Report![TblEmployeeInfoID]") but it doesn't work.

In the relationships, Department No (from TblDepartments) is related to ID
(from TblEmployeeInfo)

Why can't I use the =Dept.column(1) as I did on the form. That worked great,
but I guess it's different for a report?

Please help. Thanks.

 

[Diane]

It is still giving me an #error message on the report where the Department
name should appear

Report is generated by a query. I would like one of the text boxes to
populate the Name of Department corresponding to the Department No from a
different source (TblDepartments) instead of the query. I tried to use the
Dlookup as follows:
=DLookUp("[Name of Department]","[TblDepartments]","[Department
No]=Report![TblEmployeeInfoID]") but it doesn't work.

In the relationships, Department No (from TblDepartments) is related to ID
(from TblEmployeeInfo)

Why can't I use the =Dept.column(1) as I did on the form. That worked great,
but I guess it's different for a report?

The .Column thing works on a form because it's in a list or
combo box. Text boxes don't have columns so it doesn't
apply.

Your syntax for the DLookup you posted is incorrect. It
should be:

=DLookUp("[Name of Department]", "[TblDepartments]",
"[Department No]=Report![TblEmployeeInfo].[ID]")

 

[Diane]

Sorry Marsh, but I added the s to Report and it's still giving me the #error

It is still giving me an #error message on the report where the Department
name should appear

Diane wrote:

Report is generated by a query. I would like one of the text boxes to
populate the Name of Department corresponding to the Department No from a
different source (TblDepartments) instead of the query. I tried to use the
Dlookup as follows:
=DLookUp("[Name of Department]","[TblDepartments]","[Department
No]=Report![TblEmployeeInfoID]") but it doesn't work.

In the relationships, Department No (from TblDepartments) is related to ID
(from TblEmployeeInfo)

Why can't I use the =Dept.column(1) as I did on the form. That worked great,
but I guess it's different for a report?


The .Column thing works on a form because it's in a list or
combo box. Text boxes don't have columns so it doesn't
apply.

Your syntax for the DLookup you posted is incorrect. It
should be:

=DLookUp("[Name of Department]", "[TblDepartments]",
"[Department No]=Report![TblEmployeeInfo].[ID]")

Ahhh, I just noticed that ...=Report![TblEmp...
needs to be ...=Reports![TblEmp...