Printing Selection Criteria via print screen

  • Thread starter Thread starter Di
  • Start date Start date
D

Di

I have a database that runs off of switchboard. I can
shoot to data entry, print reports or quit. In the report
printing form, I have 30 or so options that reports can
be run from. (For example, Referral source with 6
different companies under it) I use check boxes to select
the main category and list boxes to select a sub-
category. Depending upon what category they check and
what option under that category they select, I create a
query that generates a report. Works REAL slick - but now
they want the report selection criteria printed at the
end of the report - or (even better) a printscreen of the
report selection criteria form. I cannot do it and it's
making me nuts. Any suggestions?
 
Di said:
I have a database that runs off of switchboard. I can
shoot to data entry, print reports or quit. In the report
printing form, I have 30 or so options that reports can
be run from. (For example, Referral source with 6
different companies under it) I use check boxes to select
the main category and list boxes to select a sub-
category. Depending upon what category they check and
what option under that category they select, I create a
query that generates a report. Works REAL slick - but now
they want the report selection criteria printed at the
end of the report - or (even better) a printscreen of the
report selection criteria form. I cannot do it and it's
making me nuts. Any suggestions?
Click to expand...


In the code that create's the query, create a string that
you want to display in the report. Park it in a text box on
the form so the report can retrieve it by using an
expression in a text box:
=Forms!thereportform.theformtextbox
 
I have no suggestions for your question, however, I am
trying to do something like your basic report function,
and I dont know how. I want a form full of check boxes
and the user checks all boxes they want in thier report.
How can I do that, can you help?
 
Back
Top