Change a querie's criteria using a form

[weircolin]

Hi All

Is it possible to use a form to select what information is shown in a
querie?

For instance, one of the sections of the database I am developing is
collating issues and concerns addressed by people under certain topics.
Would it be possible for me to have a combo box where you would select
what topic you wanted to see the issues for and then click a button to
show you this in the form?

Also, is there anyway for a form to populate statistics for this too,
i.e I select the topic "Benefits" and it would bring back a result
saying that "out of x number of issues, y of them were to do with
benefits"?

And would there be anyway to print this off in a report mannor? Like,
"In the month of August, 30 issues were raised and they included the
following-

10 Benefits
5 Respit
etc
etc.

Sorry, went on a bit here, didn't mean to ask as much.

Cheers

Colin

 

[Arvin Meyer [MVP]]

Have a look at the following demo database:

http://www.accessmvp.com/Arvin/Combo.zip

Even though is uses listboxes, it does exactly what you want and can use
either a list or a combo box for. This particular example actually drills
down to the record by haveing 1 listbox, fill a second list box, which then
fills the folrm. All the code and queries are there for you to copy.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[weircolin]

Arvin

Thanks for yuor reply. This is going to be really helpful.

Do you know if there is any way I could choose a month to find out
stats for that particular time?

Thanks

 

[Guest]

I have a simler issue. I have figured out how to make a criteria entry form
prompt on the opening of a report. I have entered the fromula in the
criteria field of my query, but when I select ok the criteria entered on the
form doesn't run my query. after my entry form hides the query asks for the
criteria again. Any ideas.