subreport not displaying in main report

I just realized I don't need the filter in the main report. This was an
oversight on my part as I was following a design that I use for other similar
reports. I've removed the filter in the main report and tried running it
again. To my frustration the subreport still does not display.

The subreport runs fine on its own and the main report is OK on its own,
too. I've eliminated everything I can think of that might be causing the
subreport to not display in the main report but obviously, I'm still missing
something.

I'm at a loss here. Have I come across an Access "bug"?

Thanks for your continued help!

--
www.Marzetti.com


"Ofer" wrote:

When you have in the path to the text "form" (not "forms") it's mean that the
field in a sub form
Forms![frmPKFilm].form![txtProfileID]

But to refer to a field in a subform you need
Forms![FormName]![SubFormName].Form![FieldName]

so as you can see you are missing a box
=================================
to refer to field in the main form, you need to drop the "form"
From this
Forms![frmPKFilm].form![txtProfileID]
To this
Forms![frmPKFilm]![txtProfileID]
=================================
--
I hope that helped
Good Luck


"Ofer" wrote:

Try this
The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
tblFinishedGoods.Brand Like
NZ([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand] ,"*")

Now, in the first post you mentioned something about a filter in the main
report
([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

And all my posts refer to that, this path is not possible
Forms![frmPKFilm].form![txtProfileID]
--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help, Ofer. I think I may not have been clear. Please allow
me to restate the design and desired return:

1. frmQueryReportProfilesAssociationsFGBrands is opened. It contains the
combo box cbBrand.
2. A value is selected in cbBrand and then the report rptFilm with the
subreport srptPKProfilesAssociationsFGBrands is executed.

The desired return is in the cbBrand value being filtered for in
srptPKProfilesAssociationsFGBrands.

What's happening is srptPKProfilesAssociationsFGBrands is not displaying in
the main report.

The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does this SQL meet the desired return? Access says, "No." However, I can't
find the reason.

Your initial observation that this reference is not possible:
Forms![frmPKFilm].form![txtProfileID]
And that the correct string should be:
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

doesn't seem to jive with the intent of the subreport's desired return.

I apologize for not following but I'm absolutely at a loss here.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
If you want to use the field in the sub form as a filter to the SQL or to
the Main report, then to refer to that field the text should be

Forms![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations].Form![cbBrand]

Assuming that
frmQueryReportProfilesAssociationsFGBrands = The name of the main form
sfrmPKProfilesAssociations = The name of the SubForm Frame in the main form
cbBrand = The name of the field in the sub form

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help. I think I'm making some progress but I'm still not
clear what you mean. I've revised the SQL of the subreport to:

SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]))
OR
((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]) Is Null));

This now includes the subform sfrmPKProfilesAssociations. The subreport now
displays, however, it doesn't return the expected data. Also, I'm prompted
twice to enter in a value.

What am I not understanding? I appreciate your time!!!

--
www.Marzetti.com


"Ofer" wrote:

I realized that, but in this filter you are reffering to a field in a sub
form, to filter the main report, but the path to this field in the sub form
is wrong
It should be
Forms![Main Form Name]![Sub form control name].Form![Field Name]

And you are missing a part of it.

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks, Ofer.

Actually, Forms![frmPKFilm].form![txtProfileID] is the filter in the main
report. Am I misreading your post?

--
www.Marzetti.com


"Ofer" wrote:

Hi John
This reference to the field in the sub form, is not possible
Forms![frmPKFilm].form![txtProfileID]

That right string should be
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

So, you either missing the main form name or the sub form name
--
I hope that helped
Good Luck


"JohnLute" wrote:

I posted this previously as "subreport with parameter query"." Although I
resolved part of the problem I have yet to resolve it entirely. Thanks, Allen
Browne for all your guidance!

To resolve the problems I was having with a parameter query I followed
Allen's advice and created a form in which I can enter the desired value and
then run the report. This setup works fine, however, when the main report is
executed the subreport doesn't return/appear.

I've looked at this until my eyes have fallen out of my head but can't find
the reason for the subreport not returning.

-The Master/Child links between the sub and main report are OK.
-The subreport runs fine on its own.
-The main report runs fine on its own.

I can't see the problem. I can only suppose that the filter in the main
report is a problem: ([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

Would this filter conflict with the subreport?

Here is the SQL of the main report:
SELECT tblProfiles.*, tblProfiles.Type, tblPKFMAttributes.PackagingGroup
FROM tblProfiles INNER JOIN tblPKFMAttributes ON tblProfiles.txtProfileID =
tblPKFMAttributes.txtProfileID
WHERE (((tblProfiles.Type)="FM"));

Here is the SQL of the subreport:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does anyone see what might be causing the subreport not to display?

Thanks in advance for your help!


--
www.Marzetti.com

Hi John
Check if you have any thing in the Parent child properties of the Sub report.

--
I hope that helped
Good Luck


"JohnLute" wrote:

I just realized I don't need the filter in the main report. This was an
oversight on my part as I was following a design that I use for other similar
reports. I've removed the filter in the main report and tried running it
again. To my frustration the subreport still does not display.

The subreport runs fine on its own and the main report is OK on its own,
too. I've eliminated everything I can think of that might be causing the
subreport to not display in the main report but obviously, I'm still missing
something.

I'm at a loss here. Have I come across an Access "bug"?

Thanks for your continued help!

--
www.Marzetti.com


"Ofer" wrote:

When you have in the path to the text "form" (not "forms") it's mean that the
field in a sub form
Forms![frmPKFilm].form![txtProfileID]

But to refer to a field in a subform you need
Forms![FormName]![SubFormName].Form![FieldName]

so as you can see you are missing a box
=================================
to refer to field in the main form, you need to drop the "form"
From this
Forms![frmPKFilm].form![txtProfileID]
To this
Forms![frmPKFilm]![txtProfileID]
=================================
--
I hope that helped
Good Luck


"Ofer" wrote:

Try this
The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
tblFinishedGoods.Brand Like
NZ([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand] ,"*")

Now, in the first post you mentioned something about a filter in the main
report
([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

And all my posts refer to that, this path is not possible
Forms![frmPKFilm].form![txtProfileID]
--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help, Ofer. I think I may not have been clear. Please allow
me to restate the design and desired return:

1. frmQueryReportProfilesAssociationsFGBrands is opened. It contains the
combo box cbBrand.
2. A value is selected in cbBrand and then the report rptFilm with the
subreport srptPKProfilesAssociationsFGBrands is executed.

The desired return is in the cbBrand value being filtered for in
srptPKProfilesAssociationsFGBrands.

What's happening is srptPKProfilesAssociationsFGBrands is not displaying in
the main report.

The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does this SQL meet the desired return? Access says, "No." However, I can't
find the reason.

Your initial observation that this reference is not possible:
Forms![frmPKFilm].form![txtProfileID]
And that the correct string should be:
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

doesn't seem to jive with the intent of the subreport's desired return.

I apologize for not following but I'm absolutely at a loss here.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
If you want to use the field in the sub form as a filter to the SQL or to
the Main report, then to refer to that field the text should be

Forms![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations].Form![cbBrand]

Assuming that
frmQueryReportProfilesAssociationsFGBrands = The name of the main form
sfrmPKProfilesAssociations = The name of the SubForm Frame in the main form
cbBrand = The name of the field in the sub form

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help. I think I'm making some progress but I'm still not
clear what you mean. I've revised the SQL of the subreport to:

SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]))
OR
((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]) Is Null));

This now includes the subform sfrmPKProfilesAssociations. The subreport now
displays, however, it doesn't return the expected data. Also, I'm prompted
twice to enter in a value.

What am I not understanding? I appreciate your time!!!

--
www.Marzetti.com


"Ofer" wrote:

I realized that, but in this filter you are reffering to a field in a sub
form, to filter the main report, but the path to this field in the sub form
is wrong
It should be
Forms![Main Form Name]![Sub form control name].Form![Field Name]

And you are missing a part of it.

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks, Ofer.

Actually, Forms![frmPKFilm].form![txtProfileID] is the filter in the main
report. Am I misreading your post?

--
www.Marzetti.com


"Ofer" wrote:

Hi John
This reference to the field in the sub form, is not possible
Forms![frmPKFilm].form![txtProfileID]

That right string should be
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

So, you either missing the main form name or the sub form name
--
I hope that helped
Good Luck


"JohnLute" wrote:

I posted this previously as "subreport with parameter query"." Although I
resolved part of the problem I have yet to resolve it entirely. Thanks, Allen
Browne for all your guidance!

To resolve the problems I was having with a parameter query I followed
Allen's advice and created a form in which I can enter the desired value and
then run the report. This setup works fine, however, when the main report is
executed the subreport doesn't return/appear.

I've looked at this until my eyes have fallen out of my head but can't find
the reason for the subreport not returning.

-The Master/Child links between the sub and main report are OK.
-The subreport runs fine on its own.
-The main report runs fine on its own.

I can't see the problem. I can only suppose that the filter in the main
report is a problem: ([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

Would this filter conflict with the subreport?

Here is the SQL of the main report:
SELECT tblProfiles.*, tblProfiles.Type, tblPKFMAttributes.PackagingGroup
FROM tblProfiles INNER JOIN tblPKFMAttributes ON tblProfiles.txtProfileID =
tblPKFMAttributes.txtProfileID
WHERE (((tblProfiles.Type)="FM"));

Here is the SQL of the subreport:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does anyone see what might be causing the subreport not to display?

Thanks in advance for your help!


--
www.Marzetti.com

Congratulations on your bronze status!

The Parent/Child properties are in order. That was actually one of the first
things I confirmed.

I think I've uncovered an Access bug.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
Check if you have any thing in the Parent child properties of the Sub report.

--
I hope that helped
Good Luck


"JohnLute" wrote:

I just realized I don't need the filter in the main report. This was an
oversight on my part as I was following a design that I use for other similar
reports. I've removed the filter in the main report and tried running it
again. To my frustration the subreport still does not display.

The subreport runs fine on its own and the main report is OK on its own,
too. I've eliminated everything I can think of that might be causing the
subreport to not display in the main report but obviously, I'm still missing
something.

I'm at a loss here. Have I come across an Access "bug"?

Thanks for your continued help!

--
www.Marzetti.com


"Ofer" wrote:

When you have in the path to the text "form" (not "forms") it's mean that the
field in a sub form
Forms![frmPKFilm].form![txtProfileID]

But to refer to a field in a subform you need
Forms![FormName]![SubFormName].Form![FieldName]

so as you can see you are missing a box
=================================
to refer to field in the main form, you need to drop the "form"
From this
Forms![frmPKFilm].form![txtProfileID]
To this
Forms![frmPKFilm]![txtProfileID]
=================================
--
I hope that helped
Good Luck


"Ofer" wrote:

Try this
The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
tblFinishedGoods.Brand Like
NZ([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand] ,"*")

Now, in the first post you mentioned something about a filter in the main
report
([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

And all my posts refer to that, this path is not possible
Forms![frmPKFilm].form![txtProfileID]
--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help, Ofer. I think I may not have been clear. Please allow
me to restate the design and desired return:

1. frmQueryReportProfilesAssociationsFGBrands is opened. It contains the
combo box cbBrand.
2. A value is selected in cbBrand and then the report rptFilm with the
subreport srptPKProfilesAssociationsFGBrands is executed.

The desired return is in the cbBrand value being filtered for in
srptPKProfilesAssociationsFGBrands.

What's happening is srptPKProfilesAssociationsFGBrands is not displaying in
the main report.

The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does this SQL meet the desired return? Access says, "No." However, I can't
find the reason.

Your initial observation that this reference is not possible:
Forms![frmPKFilm].form![txtProfileID]
And that the correct string should be:
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

doesn't seem to jive with the intent of the subreport's desired return.

I apologize for not following but I'm absolutely at a loss here.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
If you want to use the field in the sub form as a filter to the SQL or to
the Main report, then to refer to that field the text should be

Forms![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations].Form![cbBrand]

Assuming that
frmQueryReportProfilesAssociationsFGBrands = The name of the main form
sfrmPKProfilesAssociations = The name of the SubForm Frame in the main form
cbBrand = The name of the field in the sub form

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help. I think I'm making some progress but I'm still not
clear what you mean. I've revised the SQL of the subreport to:

SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]))
OR
((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]) Is Null));

This now includes the subform sfrmPKProfilesAssociations. The subreport now
displays, however, it doesn't return the expected data. Also, I'm prompted
twice to enter in a value.

What am I not understanding? I appreciate your time!!!

--
www.Marzetti.com


"Ofer" wrote:

I realized that, but in this filter you are reffering to a field in a sub
form, to filter the main report, but the path to this field in the sub form
is wrong
It should be
Forms![Main Form Name]![Sub form control name].Form![Field Name]

And you are missing a part of it.

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks, Ofer.

Actually, Forms![frmPKFilm].form![txtProfileID] is the filter in the main
report. Am I misreading your post?

--
www.Marzetti.com


"Ofer" wrote:

Hi John
This reference to the field in the sub form, is not possible
Forms![frmPKFilm].form![txtProfileID]

That right string should be
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

So, you either missing the main form name or the sub form name
--
I hope that helped
Good Luck


"JohnLute" wrote:

I posted this previously as "subreport with parameter query"." Although I
resolved part of the problem I have yet to resolve it entirely. Thanks, Allen
Browne for all your guidance!

To resolve the problems I was having with a parameter query I followed
Allen's advice and created a form in which I can enter the desired value and
then run the report. This setup works fine, however, when the main report is
executed the subreport doesn't return/appear.

I've looked at this until my eyes have fallen out of my head but can't find
the reason for the subreport not returning.

-The Master/Child links between the sub and main report are OK.
-The subreport runs fine on its own.
-The main report runs fine on its own.

I can't see the problem. I can only suppose that the filter in the main
report is a problem: ([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

Would this filter conflict with the subreport?

Here is the SQL of the main report:
SELECT tblProfiles.*, tblProfiles.Type, tblPKFMAttributes.PackagingGroup
FROM tblProfiles INNER JOIN tblPKFMAttributes ON tblProfiles.txtProfileID =
tblPKFMAttributes.txtProfileID
WHERE (((tblProfiles.Type)="FM"));

Here is the SQL of the subreport:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does anyone see what might be causing the subreport not to display?

Thanks in advance for your help!


--
www.Marzetti.com

Thank you

Now, let me see what we have
A sub report that display data when it runs without the mai report
The sub report show no data when running in the ain report
The child and parent properties are empty

Check if there is code on the load event of the report, that might change
the sub report data
Run compact and repair

Create the main report again, from scratc, sometimes that is the solution,
and it take less time then trying to find out the problem

--
I hope that helped
Good Luck


"JohnLute" wrote:

Congratulations on your bronze status!

The Parent/Child properties are in order. That was actually one of the first
things I confirmed.

I think I've uncovered an Access bug.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
Check if you have any thing in the Parent child properties of the Sub report.

--
I hope that helped
Good Luck


"JohnLute" wrote:

I just realized I don't need the filter in the main report. This was an
oversight on my part as I was following a design that I use for other similar
reports. I've removed the filter in the main report and tried running it
again. To my frustration the subreport still does not display.

The subreport runs fine on its own and the main report is OK on its own,
too. I've eliminated everything I can think of that might be causing the
subreport to not display in the main report but obviously, I'm still missing
something.

I'm at a loss here. Have I come across an Access "bug"?

Thanks for your continued help!

--
www.Marzetti.com


"Ofer" wrote:

When you have in the path to the text "form" (not "forms") it's mean that the
field in a sub form
Forms![frmPKFilm].form![txtProfileID]

But to refer to a field in a subform you need
Forms![FormName]![SubFormName].Form![FieldName]

so as you can see you are missing a box
=================================
to refer to field in the main form, you need to drop the "form"
From this
Forms![frmPKFilm].form![txtProfileID]
To this
Forms![frmPKFilm]![txtProfileID]
=================================
--
I hope that helped
Good Luck


"Ofer" wrote:

Try this
The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
tblFinishedGoods.Brand Like
NZ([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand] ,"*")

Now, in the first post you mentioned something about a filter in the main
report
([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

And all my posts refer to that, this path is not possible
Forms![frmPKFilm].form![txtProfileID]
--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help, Ofer. I think I may not have been clear. Please allow
me to restate the design and desired return:

1. frmQueryReportProfilesAssociationsFGBrands is opened. It contains the
combo box cbBrand.
2. A value is selected in cbBrand and then the report rptFilm with the
subreport srptPKProfilesAssociationsFGBrands is executed.

The desired return is in the cbBrand value being filtered for in
srptPKProfilesAssociationsFGBrands.

What's happening is srptPKProfilesAssociationsFGBrands is not displaying in
the main report.

The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does this SQL meet the desired return? Access says, "No." However, I can't
find the reason.

Your initial observation that this reference is not possible:
Forms![frmPKFilm].form![txtProfileID]
And that the correct string should be:
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

doesn't seem to jive with the intent of the subreport's desired return.

I apologize for not following but I'm absolutely at a loss here.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
If you want to use the field in the sub form as a filter to the SQL or to
the Main report, then to refer to that field the text should be

Forms![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations].Form![cbBrand]

Assuming that
frmQueryReportProfilesAssociationsFGBrands = The name of the main form
sfrmPKProfilesAssociations = The name of the SubForm Frame in the main form
cbBrand = The name of the field in the sub form

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help. I think I'm making some progress but I'm still not
clear what you mean. I've revised the SQL of the subreport to:

SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]))
OR
((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]) Is Null));

This now includes the subform sfrmPKProfilesAssociations. The subreport now
displays, however, it doesn't return the expected data. Also, I'm prompted
twice to enter in a value.

What am I not understanding? I appreciate your time!!!

--
www.Marzetti.com


"Ofer" wrote:

I realized that, but in this filter you are reffering to a field in a sub
form, to filter the main report, but the path to this field in the sub form
is wrong
It should be
Forms![Main Form Name]![Sub form control name].Form![Field Name]

And you are missing a part of it.

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks, Ofer.

Actually, Forms![frmPKFilm].form![txtProfileID] is the filter in the main
report. Am I misreading your post?

--
www.Marzetti.com


"Ofer" wrote:

Hi John
This reference to the field in the sub form, is not possible
Forms![frmPKFilm].form![txtProfileID]

That right string should be
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

So, you either missing the main form name or the sub form name
--
I hope that helped
Good Luck


"JohnLute" wrote:

I posted this previously as "subreport with parameter query"." Although I
resolved part of the problem I have yet to resolve it entirely. Thanks, Allen
Browne for all your guidance!

To resolve the problems I was having with a parameter query I followed
Allen's advice and created a form in which I can enter the desired value and
then run the report. This setup works fine, however, when the main report is
executed the subreport doesn't return/appear.

I've looked at this until my eyes have fallen out of my head but can't find
the reason for the subreport not returning.

-The Master/Child links between the sub and main report are OK.
-The subreport runs fine on its own.
-The main report runs fine on its own.

I can't see the problem. I can only suppose that the filter in the main
report is a problem: ([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

Would this filter conflict with the subreport?

Here is the SQL of the main report:
SELECT tblProfiles.*, tblProfiles.Type, tblPKFMAttributes.PackagingGroup
FROM tblProfiles INNER JOIN tblPKFMAttributes ON tblProfiles.txtProfileID =
tblPKFMAttributes.txtProfileID
WHERE (((tblProfiles.Type)="FM"));

Here is the SQL of the subreport:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does anyone see what might be causing the subreport not to display?

Thanks in advance for your help!


--
www.Marzetti.com

The main report has an On Format event but it has nothing to do with the
subreport. I run compact and repair every day.

I created a new main report from scratch and the subreport still doesn't
appear.

I'm about to throw in the towel.

--
www.Marzetti.com


"Ofer" wrote:

Thank you

Now, let me see what we have
A sub report that display data when it runs without the mai report
The sub report show no data when running in the ain report
The child and parent properties are empty

Check if there is code on the load event of the report, that might change
the sub report data
Run compact and repair

Create the main report again, from scratc, sometimes that is the solution,
and it take less time then trying to find out the problem

--
I hope that helped
Good Luck


"JohnLute" wrote:

Congratulations on your bronze status!

The Parent/Child properties are in order. That was actually one of the first
things I confirmed.

I think I've uncovered an Access bug.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
Check if you have any thing in the Parent child properties of the Sub report.

--
I hope that helped
Good Luck


"JohnLute" wrote:

I just realized I don't need the filter in the main report. This was an
oversight on my part as I was following a design that I use for other similar
reports. I've removed the filter in the main report and tried running it
again. To my frustration the subreport still does not display.

The subreport runs fine on its own and the main report is OK on its own,
too. I've eliminated everything I can think of that might be causing the
subreport to not display in the main report but obviously, I'm still missing
something.

I'm at a loss here. Have I come across an Access "bug"?

Thanks for your continued help!

--
www.Marzetti.com


"Ofer" wrote:

When you have in the path to the text "form" (not "forms") it's mean that the
field in a sub form
Forms![frmPKFilm].form![txtProfileID]

But to refer to a field in a subform you need
Forms![FormName]![SubFormName].Form![FieldName]

so as you can see you are missing a box
=================================
to refer to field in the main form, you need to drop the "form"
From this
Forms![frmPKFilm].form![txtProfileID]
To this
Forms![frmPKFilm]![txtProfileID]
=================================
--
I hope that helped
Good Luck


"Ofer" wrote:

Try this
The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
tblFinishedGoods.Brand Like
NZ([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand] ,"*")

Now, in the first post you mentioned something about a filter in the main
report
([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

And all my posts refer to that, this path is not possible
Forms![frmPKFilm].form![txtProfileID]
--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help, Ofer. I think I may not have been clear. Please allow
me to restate the design and desired return:

1. frmQueryReportProfilesAssociationsFGBrands is opened. It contains the
combo box cbBrand.
2. A value is selected in cbBrand and then the report rptFilm with the
subreport srptPKProfilesAssociationsFGBrands is executed.

The desired return is in the cbBrand value being filtered for in
srptPKProfilesAssociationsFGBrands.

What's happening is srptPKProfilesAssociationsFGBrands is not displaying in
the main report.

The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does this SQL meet the desired return? Access says, "No." However, I can't
find the reason.

Your initial observation that this reference is not possible:
Forms![frmPKFilm].form![txtProfileID]
And that the correct string should be:
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

doesn't seem to jive with the intent of the subreport's desired return.

I apologize for not following but I'm absolutely at a loss here.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
If you want to use the field in the sub form as a filter to the SQL or to
the Main report, then to refer to that field the text should be

Forms![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations].Form![cbBrand]

Assuming that
frmQueryReportProfilesAssociationsFGBrands = The name of the main form
sfrmPKProfilesAssociations = The name of the SubForm Frame in the main form
cbBrand = The name of the field in the sub form

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help. I think I'm making some progress but I'm still not
clear what you mean. I've revised the SQL of the subreport to:

SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]))
OR
((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]) Is Null));

This now includes the subform sfrmPKProfilesAssociations. The subreport now
displays, however, it doesn't return the expected data. Also, I'm prompted
twice to enter in a value.

What am I not understanding? I appreciate your time!!!

--
www.Marzetti.com


"Ofer" wrote:

I realized that, but in this filter you are reffering to a field in a sub
form, to filter the main report, but the path to this field in the sub form
is wrong
It should be
Forms![Main Form Name]![Sub form control name].Form![Field Name]

And you are missing a part of it.

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks, Ofer.

Actually, Forms![frmPKFilm].form![txtProfileID] is the filter in the main
report. Am I misreading your post?

--
www.Marzetti.com


"Ofer" wrote:

Hi John
This reference to the field in the sub form, is not possible
Forms![frmPKFilm].form![txtProfileID]

That right string should be
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

So, you either missing the main form name or the sub form name
--
I hope that helped
Good Luck


"JohnLute" wrote:

I posted this previously as "subreport with parameter query"." Although I
resolved part of the problem I have yet to resolve it entirely. Thanks, Allen
Browne for all your guidance!

To resolve the problems I was having with a parameter query I followed
Allen's advice and created a form in which I can enter the desired value and
then run the report. This setup works fine, however, when the main report is
executed the subreport doesn't return/appear.

I've looked at this until my eyes have fallen out of my head but can't find
the reason for the subreport not returning.

-The Master/Child links between the sub and main report are OK.
-The subreport runs fine on its own.
-The main report runs fine on its own.

I can't see the problem. I can only suppose that the filter in the main
report is a problem: ([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

Would this filter conflict with the subreport?

Here is the SQL of the main report:
SELECT tblProfiles.*, tblProfiles.Type, tblPKFMAttributes.PackagingGroup
FROM tblProfiles INNER JOIN tblPKFMAttributes ON tblProfiles.txtProfileID =
tblPKFMAttributes.txtProfileID
WHERE (((tblProfiles.Type)="FM"));

Here is the SQL of the subreport:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does anyone see what might be causing the subreport not to display?

Thanks in advance for your help!


--
www.Marzetti.com

Mybe, if the data is in the page header it wont display as a sub report, as a
sub report you can see only the report header and the details

--
I hope that helped
Good Luck


"JohnLute" wrote:

The main report has an On Format event but it has nothing to do with the
subreport. I run compact and repair every day.

I created a new main report from scratch and the subreport still doesn't
appear.

I'm about to throw in the towel.

--
www.Marzetti.com


"Ofer" wrote:

Thank you

Now, let me see what we have
A sub report that display data when it runs without the mai report
The sub report show no data when running in the ain report
The child and parent properties are empty

Check if there is code on the load event of the report, that might change
the sub report data
Run compact and repair

Create the main report again, from scratc, sometimes that is the solution,
and it take less time then trying to find out the problem

--
I hope that helped
Good Luck


"JohnLute" wrote:

Congratulations on your bronze status!

The Parent/Child properties are in order. That was actually one of the first
things I confirmed.

I think I've uncovered an Access bug.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
Check if you have any thing in the Parent child properties of the Sub report.

--
I hope that helped
Good Luck


"JohnLute" wrote:

I just realized I don't need the filter in the main report. This was an
oversight on my part as I was following a design that I use for other similar
reports. I've removed the filter in the main report and tried running it
again. To my frustration the subreport still does not display.

The subreport runs fine on its own and the main report is OK on its own,
too. I've eliminated everything I can think of that might be causing the
subreport to not display in the main report but obviously, I'm still missing
something.

I'm at a loss here. Have I come across an Access "bug"?

Thanks for your continued help!

--
www.Marzetti.com


"Ofer" wrote:

When you have in the path to the text "form" (not "forms") it's mean that the
field in a sub form
Forms![frmPKFilm].form![txtProfileID]

But to refer to a field in a subform you need
Forms![FormName]![SubFormName].Form![FieldName]

so as you can see you are missing a box
=================================
to refer to field in the main form, you need to drop the "form"
From this
Forms![frmPKFilm].form![txtProfileID]
To this
Forms![frmPKFilm]![txtProfileID]
=================================
--
I hope that helped
Good Luck


"Ofer" wrote:

Try this
The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
tblFinishedGoods.Brand Like
NZ([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand] ,"*")

Now, in the first post you mentioned something about a filter in the main
report
([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

And all my posts refer to that, this path is not possible
Forms![frmPKFilm].form![txtProfileID]
--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help, Ofer. I think I may not have been clear. Please allow
me to restate the design and desired return:

1. frmQueryReportProfilesAssociationsFGBrands is opened. It contains the
combo box cbBrand.
2. A value is selected in cbBrand and then the report rptFilm with the
subreport srptPKProfilesAssociationsFGBrands is executed.

The desired return is in the cbBrand value being filtered for in
srptPKProfilesAssociationsFGBrands.

What's happening is srptPKProfilesAssociationsFGBrands is not displaying in
the main report.

The SQL of the subreport is:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand FROM (tblProfiles LEFT JOIN tblFinishedGoods ON
tblProfiles.txtProfileID = tblFinishedGoods.txtProfileID) INNER JOIN
tblPKProfilesAssociations ON tblProfiles.txtProfileID =
tblPKProfilesAssociations.ProfilesAssociations WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));

Does this SQL meet the desired return? Access says, "No." However, I can't
find the reason.

Your initial observation that this reference is not possible:
Forms![frmPKFilm].form![txtProfileID]
And that the correct string should be:
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

doesn't seem to jive with the intent of the subreport's desired return.

I apologize for not following but I'm absolutely at a loss here.

--
www.Marzetti.com


"Ofer" wrote:

Hi John
If you want to use the field in the sub form as a filter to the SQL or to
the Main report, then to refer to that field the text should be

Forms![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations].Form![cbBrand]

Assuming that
frmQueryReportProfilesAssociationsFGBrands = The name of the main form
sfrmPKProfilesAssociations = The name of the SubForm Frame in the main form
cbBrand = The name of the field in the sub form

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks for your help. I think I'm making some progress but I'm still not
clear what you mean. I've revised the SQL of the subreport to:

SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]))
OR
((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![sfrmPKProfilesAssociations]![cbBrand]) Is Null));

This now includes the subform sfrmPKProfilesAssociations. The subreport now
displays, however, it doesn't return the expected data. Also, I'm prompted
twice to enter in a value.

What am I not understanding? I appreciate your time!!!

--
www.Marzetti.com


"Ofer" wrote:

I realized that, but in this filter you are reffering to a field in a sub
form, to filter the main report, but the path to this field in the sub form
is wrong
It should be
Forms![Main Form Name]![Sub form control name].Form![Field Name]

And you are missing a part of it.

--
I hope that helped
Good Luck


"JohnLute" wrote:

Thanks, Ofer.

Actually, Forms![frmPKFilm].form![txtProfileID] is the filter in the main
report. Am I misreading your post?

--
www.Marzetti.com


"Ofer" wrote:

Hi John
This reference to the field in the sub form, is not possible
Forms![frmPKFilm].form![txtProfileID]

That right string should be
Forms![MainFormName]![Sub Form control name].form![txtProfileID]

So, you either missing the main form name or the sub form name
--
I hope that helped
Good Luck


"JohnLute" wrote:

I posted this previously as "subreport with parameter query"." Although I
resolved part of the problem I have yet to resolve it entirely. Thanks, Allen
Browne for all your guidance!

To resolve the problems I was having with a parameter query I followed
Allen's advice and created a form in which I can enter the desired value and
then run the report. This setup works fine, however, when the main report is
executed the subreport doesn't return/appear.

I've looked at this until my eyes have fallen out of my head but can't find
the reason for the subreport not returning.

-The Master/Child links between the sub and main report are OK.
-The subreport runs fine on its own.
-The main report runs fine on its own.

I can't see the problem. I can only suppose that the filter in the main
report is a problem: ([tblProfiles.txtProfileID] =
Forms![frmPKFilm].form![txtProfileID])

Would this filter conflict with the subreport?

Here is the SQL of the main report:
SELECT tblProfiles.*, tblProfiles.Type, tblPKFMAttributes.PackagingGroup
FROM tblProfiles INNER JOIN tblPKFMAttributes ON tblProfiles.txtProfileID =
tblPKFMAttributes.txtProfileID
WHERE (((tblProfiles.Type)="FM"));

Here is the SQL of the subreport:
SELECT tblPKProfilesAssociations.ProfilesAssociations,
tblProfiles.Description, tblProfiles.Type,
tblPKProfilesAssociations.Quantity, tblPKProfilesAssociations.Comments,
tblPKProfilesAssociations.txtProfileID, tblProfiles.AssociationNotes,
tblFinishedGoods.Brand
FROM (tblProfiles LEFT JOIN tblFinishedGoods ON tblProfiles.txtProfileID =
tblFinishedGoods.txtProfileID) INNER JOIN tblPKProfilesAssociations ON
tblProfiles.txtProfileID = tblPKProfilesAssociations.ProfilesAssociations
WHERE
(((tblFinishedGoods.Brand)=[Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]))
OR ((([Forms]![frmQueryReportProfilesAssociationsFGBrands]![cbBrand]) Is
Null));