Please Help! Extremely urgent!!!

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

How do i print a report for just a certain type of forms?
I need to seperate the forms into no and yes categories
and print just the no ones. How can i get the computer to
do this for me?Please reply right away.
 
Build a nice prompt form with two buttons. the first button will print all
the ones for Yes.

The code behind the button would look like:

docmd.OpenReport "the report",acViewPreview,,"yesNoField = True"

The code behind the other button could be:

docmd.OpenReport "the report",acViewPreview,,"yesNoField = false"

The above trick revolves around using the "where" clause when you open the
report. I do this all the time. Take a look at:

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
 
Back
Top