Save As Command Can't save any subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Leslie said:
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,
Click to expand...

You used subforms inside a report instead of subreports.
 
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
 
Leslie said:
No I use subreports inside reports not subforms hence the question as
to why I'm getting that message and what it means.
Click to expand...

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.
 
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.
 
Leslie said:
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.
Click to expand...

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.
 
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,
 
Leslie said:
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?
Click to expand...

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.
 
Back
Top