Save As Command Can't save any subforms

[Leslie]

When testing a change (adding a reject e-mail) to an existing database I'm
getting this screen:

"The Save As command can't process any subforms contained in your report"
Do you want to proceed anyway?

I have never seen this message before what is wrong? The form does have a
subform, but the report does not.

Thanks,

 

[Rick Brandt]

When testing a change (adding a reject e-mail) to an existing
database I'm getting this screen:

"The Save As command can't process any subforms contained in your
report" Do you want to proceed anyway?

I have never seen this message before what is wrong? The form does
have a subform, but the report does not.

Thanks,

You used subforms inside a report instead of subreports.

 

[Leslie]

No I use subreports inside reports not subforms hence the question as to why
I'm getting that message and what it means.

Thanks,
Leslie

 

[Rick Brandt]

No I use subreports inside reports not subforms hence the question as
to why I'm getting that message and what it means.

Did you by any chance use the "Save as Report" option on a form that
contained subforms? When doing that only the parent form is re-created as a
report. The subforms STAY as subforms.

That is the only time I have seen the message you are describing.

 

[Leslie]

Yes both the form and report have subs the subform has a subform for that
form and the report has a subreport for that report. So does that mean that
it isn't saving the subform and it isn't a large problem? I have never seen
this before and I use forms/subform and report/subreports all the time.

 

[Rick Brandt]

Yes both the form and report have subs the subform has a subform for
that form and the report has a subreport for that report. So does
that mean that it isn't saving the subform and it isn't a large
problem? I have never seen this before and I use forms/subform and
report/subreports all the time.

The point that I might not be making as clearly as I would like is that what you
think is a subreport might actually be a subform. Access will allow you to put
a form inside a report and it will act very much like a subreport. That is
until you try to use OutputTo or SendObject on it at which point you will get
the error you are seeing.

Bottom line, make absolutely sure that all of your subreports are in fact using
reports as their SourceObject and not forms.

 

[Leslie]

Thank you I will verify that. One more question can the subform be used when
you have created the report from the report design wizard?

Thanks,

 

[Rick Brandt]

Thank you I will verify that. One more question can the subform be
used when you have created the report from the report design wizard?

I don't know about that. Where it is easy to get this condition is to take a
form with one or more subforms and use the right-click option to "Save as a
Report" on the main form. It creates a report based on the design of the main
form, but the subforms are still subforms. They each need to be converted to
reports separately.