Tina,

I've learned that a subreport without data will never show up under any circumstance so I had to recreate the subform controls on the main report. I had to set the controls visible depending on whether the subreport has data, using the Format event. The thread on my post has the details.
--
Greg Blair
CNV Software
Minneapolis MN


" wrote:

Greg:

I saw your post shortly after I posted mine. I hope we
get a response, but I'm not optimistic what we are trying
to do will work. I know there is an event property in the
properties box of the report called "Has no data" but I
don't know what code to put in it. I'll keep trying and
waiting for a response. Hopefully we'll get one!

Tina
-----Original Message-----
Tina,

I don't have an answer for you but you might want to
watch the next post from me as well. I am trying to solve
the same problem. I posted this problem in late June with
no replies so I posted again today.

I'm currently trying to add a blank record to the
recordset for the subform but I'm not finding the right
place to add the record. I'll let you know if I succeed.

HTH,
--
Greg Blair
CNV Software
Minneapolis MN


" wrote:

I have designed an equipment inventory db. I have to
conduct an inventory of our equipment and want to print
out what I have so far so I can make any changes to it
and
add equipment that isn't accounted for.

I have designed a report by employee with 4 subreports
which identify the computer, monitor, printer and any
peripherals the employee has been assigned. Each
equipment type is a separate subform.

For some employees, we have no information. For
others,
we have the computer and printer, but no monitor or
peripheral info.

The tables are set up so that there is one main table
(tblInventory) and 4 additional tables (tblComputer,
tblPeripheral, tblMonitor, tblPrinter) with information
specific only to that equipment type in the secondary
table. Each table has a relationship with the main
table.

How can I design my report so that all 4 subreports
print,
with or without data? Right now, if an employee has a
computer, but no other information in the database,
only
the computer subform prints and the rest of the page is
blank.

Thanks in advance for any help!
Tina

.