Text box in a report that displays the results of a query

[StevePrefontaine via AccessMonster.com]

Hi,

What I am looking to do is populate a text box in a report that is based on
the results of a query. From what I understand, I can't use the DLookup
function since I need to display multiple records. Also, I was able to do
this using a list box; however, I would need it to be transparent, which I
was unable to do.

If it helps, the query in question is titled qryEmployeeTimesheet. The code
for it is as follows:

SELECT DISTINCTROW tblEng.proj_num
FROM tblEng
GROUP BY tblEng.proj_num, tblEng.employee, tblEng.week_end
HAVING (((tblEng.proj_num)<>"N/A") AND ((tblEng.employee)=[Forms]![frmEng1]!
[txtEmployee]) AND ((tblEng.week_end)=[Forms]![frmEng1]![txtweek_end]));

Basically, this query takes the Week Ending and Employee Name from a form
(frmEng1) and creates a list of projects that employee worked on for that
week ending based on a table (tblEng). I now want my form to display the list
of these projects in a text box.

-StevePre

 

[KARL DEWEY]

Why not a subreport?

 

[StevePrefontaine via AccessMonster.com]

That worked well. I've never used subreports before. I guess that was a very
newbie question. Thanks for your help.

Why not a subreport?

Hi,

[quoted text clipped - 19 lines]

-StevePre