Datasheet View

[briank]

My report includes several subreports. These subreports were originally
created as forms where the default view was datasheet. I would like to
continue using the datasheet view in the subreport but this does not appear
to be an option within Access. Is there a way to programically alter the
subreport to output as a datasheet?

 

[Larry Linson]

My report includes several subreports. These subreports
were originally created as forms where the default view
was datasheet. I would like to continue using the datasheet
view in the subreport but this does not appear to be an
option within Access. Is there a way to programically
alter the subreport to output as a datasheet?

When I embed a Form, with its Default View set to Datasheet, in a Subreport
Control, it displays in Datasheet View (in Access 2003).

Did you save your original Forms as Reports? Reports do not have the
Default View property, as Forms do.

You can display a Form in a Subreport Control, but you cannot display a
Report in a Subform Control.

(The information above applies through Access 2003. There have been some
changes / enhancements to Reporting in Access 2007, but I have not had the
opportunity to explore or investigate them.)

Larry Linson
Microsoft Access MVP

 

[briank]

Thanks for the tip Larry. Using the form in my report was the answer.

 

[Kari]

I tried that, but now I have a new problem.

I have a report with a form as a subreport, so that I can show the datasheet
view. The report works great on screen, printing and sending as a PDF.
However, when it closes, Access insists on asking if I want to save the
changes to the form underlying the subreport control. I have tried
everything I can think of to get rid of this message, but it won't go away.

Does anyone have any suggestions?

I have tried explicitly closing the subform (DoCmd.Close acReport,
"Reports![PO Report]![PO Order Details subform for PO Report].Form",
acSaveNo), or saving it first (DoCmd.Save acReport, "Reports![PO Report]![PO
Order Details subform for PO Report].Form" ). Closing doesn't do anything,
and saving generates an error ("Object not open").

I can't change to a form because I need to be able to send it as a PDF.

Somebody please help before I pull all of my hair out!

Kari