Can't generate separate report for individual requisitions

I have a requisition form that needs to generate it's own individual report.
I have tried everything and can't figure out why the report shows all
requisitions entered instead of a single report for each requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

The recordsource and any filtering and/or where clauses would be helpful -
as it stands we have no way of knowing what the actual data being pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own individual
report.
I have tried everything and can't figure out why the report shows all
requisitions entered instead of a single report for each requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

Can we assume you have a similiar statement such as this in the OnClick event
of the print command button?

stDocName = "Your Report Name"
DoCmd.OpenReport stDocName, acPreview, , "[RequisitionID] =
Forms![RequisitionForm]![RequisitionID]"

I use this and another version of this to filter all of my reports to match
the current record of the form from which I am printing.



"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be helpful -
as it stands we have no way of knowing what the actual data being pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own individual
report.
I have tried everything and can't figure out why the report shows all
requisitions entered instead of a single report for each requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

The record source is from a table of the same name, the subform is an
auto-lookup from a query.

I am using a filter as follows:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter Query"

Where clause for the filter is as follows:

WHERE
((([Requisition].[MaterialRequisitionNumber])=[Forms]![Requisition]![MaterialRequisitionNumber]));

Hope this helps - I still can't figure out what is wrong.

Thank you.




"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be helpful -
as it stands we have no way of knowing what the actual data being pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own individual
report.
I have tried everything and can't figure out why the report shows all
requisitions entered instead of a single report for each requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

Since each requisition has it's own number try putting a text box in a group
header section and used the record number as the source. Set the properties
to break after section which will put each record on a separate page. If your
subreport is in the details section it should carry with the requisition
number for each page.

HTH
scruffy

"lisedum" wrote:

The record source is from a table of the same name, the subform is an
auto-lookup from a query.

I am using a filter as follows:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter Query"

Where clause for the filter is as follows:

WHERE
((([Requisition].[MaterialRequisitionNumber])=[Forms]![Requisition]![MaterialRequisitionNumber]));

Hope this helps - I still can't figure out what is wrong.

Thank you.




"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be helpful -
as it stands we have no way of knowing what the actual data being pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own individual
report.
I have tried everything and can't figure out why the report shows all
requisitions entered instead of a single report for each requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

Thank you,

That was not exactly it, but from your answer I was able to figure out what
was wrong.

Now I have another printing problem.

When I click on the print requisition button from the form, it prompts for
the requisition number with a dialog box: "Enter Parameter Value" and I
don't know why. I have a filter to print the requisition as follows:

SELECT Requisition.*
FROM Requisition
WHERE
(((Requisition.MaterialRequisitionNumber)=[Forms]![Requisition]![MaterialRequisitionNumber]));

And in the event procedure I have the following:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter"

I don't want it to prompt for the number, just to print the current
requisition on the form and I can't figure out why it is not doing this.

Thank you.



"scruffy" wrote:

Since each requisition has it's own number try putting a text box in a group
header section and used the record number as the source. Set the properties
to break after section which will put each record on a separate page. If your
subreport is in the details section it should carry with the requisition
number for each page.

HTH
scruffy

"lisedum" wrote:

The record source is from a table of the same name, the subform is an
auto-lookup from a query.

I am using a filter as follows:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter Query"

Where clause for the filter is as follows:

WHERE
((([Requisition].[MaterialRequisitionNumber])=[Forms]![Requisition]![MaterialRequisitionNumber]));

Hope this helps - I still can't figure out what is wrong.

Thank you.




"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be helpful -
as it stands we have no way of knowing what the actual data being pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own individual
report.
I have tried everything and can't figure out why the report shows all
requisitions entered instead of a single report for each requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

I haven't ever used the query argument of DoCmd.OpenReport and haven't seen
others recommend it. The method I use is like:

Dim strWhere as String
strWhere = "MaterialRequisitionNumber = " & Me.MaterialRequisitionNumber
strDocName = "Requisition"
'Print Requisition Report using the where clause
DoCmd.OpenReport strDocName, acViewNormal, ,strWhere

--
Duane Hookom
MS Access MVP


"lisedum" wrote in message
...
Thank you,

That was not exactly it, but from your answer I was able to figure out
what
was wrong.

Now I have another printing problem.

When I click on the print requisition button from the form, it prompts for
the requisition number with a dialog box: "Enter Parameter Value" and I
don't know why. I have a filter to print the requisition as follows:

SELECT Requisition.*
FROM Requisition
WHERE
(((Requisition.MaterialRequisitionNumber)=[Forms]![Requisition]![MaterialRequisitionNumber]));

And in the event procedure I have the following:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter"

I don't want it to prompt for the number, just to print the current
requisition on the form and I can't figure out why it is not doing this.

Thank you.



"scruffy" wrote:

Since each requisition has it's own number try putting a text box in a
group
header section and used the record number as the source. Set the
properties
to break after section which will put each record on a separate page. If
your
subreport is in the details section it should carry with the requisition
number for each page.

HTH
scruffy

"lisedum" wrote:

The record source is from a table of the same name, the subform is an
auto-lookup from a query.

I am using a filter as follows:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter
Query"

Where clause for the filter is as follows:

WHERE
((([Requisition].[MaterialRequisitionNumber])=[Forms]![Requisition]![MaterialRequisitionNumber]));

Hope this helps - I still can't figure out what is wrong.

Thank you.




"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be
helpful -
as it stands we have no way of knowing what the actual data being
pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own individual
report.
I have tried everything and can't figure out why the report shows
all
requisitions entered instead of a single report for each
requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the
requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

I tried it and it still prompts me to enter the requisition number. Even if
I enter the requisition number, it will still print all requisitions.

I have no idea why it won't print the current one only.

Thank you.

"Duane Hookom" wrote:

I haven't ever used the query argument of DoCmd.OpenReport and haven't seen
others recommend it. The method I use is like:

Dim strWhere as String
strWhere = "MaterialRequisitionNumber = " & Me.MaterialRequisitionNumber
strDocName = "Requisition"
'Print Requisition Report using the where clause
DoCmd.OpenReport strDocName, acViewNormal, ,strWhere

--
Duane Hookom
MS Access MVP


"lisedum" wrote in message
...
Thank you,

That was not exactly it, but from your answer I was able to figure out
what
was wrong.

Now I have another printing problem.

When I click on the print requisition button from the form, it prompts for
the requisition number with a dialog box: "Enter Parameter Value" and I
don't know why. I have a filter to print the requisition as follows:

SELECT Requisition.*
FROM Requisition
WHERE
(((Requisition.MaterialRequisitionNumber)=[Forms]![Requisition]![MaterialRequisitionNumber]));

And in the event procedure I have the following:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter"

I don't want it to prompt for the number, just to print the current
requisition on the form and I can't figure out why it is not doing this.

Thank you.



"scruffy" wrote:

Since each requisition has it's own number try putting a text box in a
group
header section and used the record number as the source. Set the
properties
to break after section which will put each record on a separate page. If
your
subreport is in the details section it should carry with the requisition
number for each page.

HTH
scruffy

"lisedum" wrote:

The record source is from a table of the same name, the subform is an
auto-lookup from a query.

I am using a filter as follows:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter
Query"

Where clause for the filter is as follows:

WHERE
((([Requisition].[MaterialRequisitionNumber])=[Forms]![Requisition]![MaterialRequisitionNumber]));

Hope this helps - I still can't figure out what is wrong.

Thank you.




"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be
helpful -
as it stands we have no way of knowing what the actual data being
pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own individual
report.
I have tried everything and can't figure out why the report shows
all
requisitions entered instead of a single report for each
requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the
requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

Confirm that you have a numeric field in your report's record named
"MaterialRequisitionNumber" and a control on your form named
"MatericalRequistionNumber".

--
Duane Hookom
MS Access MVP

"lisedum" wrote in message
...
I tried it and it still prompts me to enter the requisition number. Even
if
I enter the requisition number, it will still print all requisitions.

I have no idea why it won't print the current one only.

Thank you.

"Duane Hookom" wrote:

I haven't ever used the query argument of DoCmd.OpenReport and haven't
seen
others recommend it. The method I use is like:

Dim strWhere as String
strWhere = "MaterialRequisitionNumber = " & Me.MaterialRequisitionNumber
strDocName = "Requisition"
'Print Requisition Report using the where clause
DoCmd.OpenReport strDocName, acViewNormal, ,strWhere

--
Duane Hookom
MS Access MVP


"lisedum" wrote in message
...
Thank you,

That was not exactly it, but from your answer I was able to figure out
what
was wrong.

Now I have another printing problem.

When I click on the print requisition button from the form, it prompts
for
the requisition number with a dialog box: "Enter Parameter Value" and
I
don't know why. I have a filter to print the requisition as follows:

SELECT Requisition.*
FROM Requisition
WHERE
(((Requisition.MaterialRequisitionNumber)=[Forms]![Requisition]![MaterialRequisitionNumber]));

And in the event procedure I have the following:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter"

I don't want it to prompt for the number, just to print the current
requisition on the form and I can't figure out why it is not doing
this.

Thank you.



"scruffy" wrote:

Since each requisition has it's own number try putting a text box in a
group
header section and used the record number as the source. Set the
properties
to break after section which will put each record on a separate page.
If
your
subreport is in the details section it should carry with the
requisition
number for each page.

HTH
scruffy

"lisedum" wrote:

The record source is from a table of the same name, the subform is
an
auto-lookup from a query.

I am using a filter as follows:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter
Query"

Where clause for the filter is as follows:

WHERE
((([Requisition].[MaterialRequisitionNumber])=[Forms]![Requisition]![MaterialRequisitionNumber]));

Hope this helps - I still can't figure out what is wrong.

Thank you.




"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be
helpful -
as it stands we have no way of knowing what the actual data being
pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own
individual
report.
I have tried everything and can't figure out why the report
shows
all
requisitions entered instead of a single report for each
requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the
requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.

Yes, I double checked and I do.



"Duane Hookom" wrote:

Confirm that you have a numeric field in your report's record named
"MaterialRequisitionNumber" and a control on your form named
"MatericalRequistionNumber".

--
Duane Hookom
MS Access MVP

"lisedum" wrote in message
...
I tried it and it still prompts me to enter the requisition number. Even
if
I enter the requisition number, it will still print all requisitions.

I have no idea why it won't print the current one only.

Thank you.

"Duane Hookom" wrote:

I haven't ever used the query argument of DoCmd.OpenReport and haven't
seen
others recommend it. The method I use is like:

Dim strWhere as String
strWhere = "MaterialRequisitionNumber = " & Me.MaterialRequisitionNumber
strDocName = "Requisition"
'Print Requisition Report using the where clause
DoCmd.OpenReport strDocName, acViewNormal, ,strWhere

--
Duane Hookom
MS Access MVP


"lisedum" wrote in message
...
Thank you,

That was not exactly it, but from your answer I was able to figure out
what
was wrong.

Now I have another printing problem.

When I click on the print requisition button from the form, it prompts
for
the requisition number with a dialog box: "Enter Parameter Value" and
I
don't know why. I have a filter to print the requisition as follows:

SELECT Requisition.*
FROM Requisition
WHERE
(((Requisition.MaterialRequisitionNumber)=[Forms]![Requisition]![MaterialRequisitionNumber]));

And in the event procedure I have the following:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter"

I don't want it to prompt for the number, just to print the current
requisition on the form and I can't figure out why it is not doing
this.

Thank you.



"scruffy" wrote:

Since each requisition has it's own number try putting a text box in a
group
header section and used the record number as the source. Set the
properties
to break after section which will put each record on a separate page.
If
your
subreport is in the details section it should carry with the
requisition
number for each page.

HTH
scruffy

"lisedum" wrote:

The record source is from a table of the same name, the subform is
an
auto-lookup from a query.

I am using a filter as follows:

Dim strDocName As String

strDocName = "Requisition"
'Print Requisition Report using Requisition Filter Query
DoCmd.OpenReport strDocName, acViewNormal, "Requisition Filter
Query"

Where clause for the filter is as follows:

WHERE
((([Requisition].[MaterialRequisitionNumber])=[Forms]![Requisition]![MaterialRequisitionNumber]));

Hope this helps - I still can't figure out what is wrong.

Thank you.




"SusanV" wrote:

The recordsource and any filtering and/or where clauses would be
helpful -
as it stands we have no way of knowing what the actual data being
pulled
might be...
--
hth,
SusanV


"lisedum" wrote in message
...
I have a requisition form that needs to generate it's own
individual
report.
I have tried everything and can't figure out why the report
shows
all
requisitions entered instead of a single report for each
requisition. All
requisitions print continuously on one single report.

The requisition has an auto number with a subform for the
requisition
details that has an auto-lookup based on a query.

I hope someone has the answer!

Thank you.