Check Buttons for Parameters

L

Lee

I am creating a unbound form. I also have about 7 reports.
Parameters are set on all these reports to either display CAT FIN, COSO,
M&E, or all.

So if you type in the parameter the one of the above, or all of the above
parameters it will run the report.

I was wondering how do I link my check buttons so the user can easily check
which parameters he wishes to select then preview all the reports with those
parameters. Thanks

Please go step by step, since I am a new to this.
 
M

[MVP] S.Clark

I do it the other way. I let the user select the report, then en/disable
the control of which they're allowed to select for the report.

I create a table to hold the report name and have a Yes/No column for each
criteria control on the unbound form. (I suppose you could normalize it.)
Anyway, after the user selects the report name, I use those entries to
determine what's on and off.
 
L

Lee

I wrote this question because i had this problem first. No one can seem to
help me on this one.

So I was trying to create a form that you can select the parameter, which I
don't know how to do, and then it would create the filter to preview all my
reports.

Hello,

I am a beginner in Access. I was wondering step by step if someone could
help me?

I made a report that is based off of a query. The query has in total 15
queries and a main query that sets the parameter. So the parameters carry
over the 15 queries.
In my criteria field I set the parameters in the main query as followed:
[Enter CAT]
[Enter M&E]
[Enter COSO]

The report is based of this main query with a sub report from 1 of the 15
queries. When running the report it ask me to input the values three times
(CAT, M&E, and COSO), which is fine. But then it asks me to repeat the
values again for another 4 times before the report opens. Is there a way to
bypass all this and input the values just once so it can immediately populate
my report?

Remind you, when you enter one of the criteria's it will just return that
criteria’s value. If you input all three, it will return the population, and
so on. But I just want it once.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top