Print records in continuous form

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

Guest

I have a Continuous Form that based on a Query that selects record according
to the Month.
What I want to do is to be able to print all the records in this Form by one
Command button. So I have the report designed and I have created a Macro
“Open Report†+Print Out, but it opens only the first record to print.
I did the Where condition on the Command Button On Click:
[PM#]=[Forms]![FormName]![PM#]. But it’s not working how I want it to work.
How I can print all the records?

Thanks for the help.
 
Take this part out, it is the problem
[PM#]=[Forms]![FormName]![PM#]

It is filtering the report based on the current record in the form.
 
Thank you for the reply. This report is not only for this Form, I use this
report to print from different forms that operated by macros. I don’t want to
make another report only for this form, I would like to use it here as well.
Is there any way to do it?

Thanks again.


Klatuu said:
Take this part out, it is the problem
[PM#]=[Forms]![FormName]![PM#]

It is filtering the report based on the current record in the form.
--
Dave Hargis, Microsoft Access MVP


Anna said:
I have a Continuous Form that based on a Query that selects record according
to the Month.
What I want to do is to be able to print all the records in this Form by one
Command button. So I have the report designed and I have created a Macro
“Open Report†+Print Out, but it opens only the first record to print.
I did the Where condition on the Command Button On Click:
[PM#]=[Forms]![FormName]![PM#]. But it’s not working how I want it to work.
How I can print all the records?

Thanks for the help.
Click to expand...
Click to expand...
 
If you are using Macros, then rather than a different report, use a different
macro without the Where.
--
Dave Hargis, Microsoft Access MVP


Anna said:
Thank you for the reply. This report is not only for this Form, I use this
report to print from different forms that operated by macros. I don’t want to
make another report only for this form, I would like to use it here as well.
Is there any way to do it?

Thanks again.


Klatuu said:
Take this part out, it is the problem
[PM#]=[Forms]![FormName]![PM#]

It is filtering the report based on the current record in the form.
--
Dave Hargis, Microsoft Access MVP


Anna said:
I have a Continuous Form that based on a Query that selects record according
to the Month.
What I want to do is to be able to print all the records in this Form by one
Command button. So I have the report designed and I have created a Macro
“Open Report†+Print Out, but it opens only the first record to print.
I did the Where condition on the Command Button On Click:
[PM#]=[Forms]![FormName]![PM#]. But it’s not working how I want it to work.
How I can print all the records?

Thanks for the help.
Click to expand...
Click to expand...
Click to expand...
 
I have tried that and it opens the report with all the records from the
original table, but I need it to open only the once that I have on the form.


Klatuu said:
If you are using Macros, then rather than a different report, use a different
macro without the Where.
--
Dave Hargis, Microsoft Access MVP


Anna said:
Thank you for the reply. This report is not only for this Form, I use this
report to print from different forms that operated by macros. I don’t want to
make another report only for this form, I would like to use it here as well.
Is there any way to do it?

Thanks again.


Klatuu said:
Take this part out, it is the problem
[PM#]=[Forms]![FormName]![PM#]

It is filtering the report based on the current record in the form.
--
Dave Hargis, Microsoft Access MVP


:

I have a Continuous Form that based on a Query that selects record according
to the Month.
What I want to do is to be able to print all the records in this Form by one
Command button. So I have the report designed and I have created a Macro
“Open Report†+Print Out, but it opens only the first record to print.
I did the Where condition on the Command Button On Click:
[PM#]=[Forms]![FormName]![PM#]. But it’s not working how I want it to work.
How I can print all the records?

Thanks for the help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top