Report Distribution List

[mvuhu_accessforum]

I have a form that collects the data. A button then calls up another
where you select the people on a distribution list. A button on the
distribution form then opens the report. The reports reads from a


query for he data and a DLOOKUP from the distribution list for the
list of people. I see the report 100% in preview. The moment i try
print or email the report the data read via the DLOOKUP from the
distribution form has the following error: #NAME?

How do i fix this?

[pbaldy]

Does the DLookup() use a form that got closed between the report being opened and printed?