Printing Selection Criteria via print screen

[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?

 

[Marshall Barton]

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?

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

 

[Dave]

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?

 

[r0adhog]

If you are looking for a print screen utility for access look at
http://files.bdmco.com/PrintScreen.mdb

cheers...

rh