Requesting Sort Of Data With A Input Box

[Warren]

I want to be able to click on a report and have a input
box pop-up with different sort criteria input options, Ex:
(music) country/western, slow. how do I implement the pop-
up box to appear when I click on the respective report
button.

Thank You

 

[Jeff Boyce]

Warren

One way would be to build a form that pops up. Set your selection and
sorting criteria on the form, then have the query and/or report "look at"
the form's controls for guidance.

Good luck

Jeff Boyce
<Access MVP>

 

[Warren]

-----Original Message-----
Warren

One way would be to build a form that pops up. Set your selection and
sorting criteria on the form, then have the query and/or report "look at"
the form's controls for guidance.

Good luck

Jeff Boyce
<Access MVP>

.
Jeff, thank you for the reply. I like to build A Search

Form. What would I set The Forms Selection/Criteria to. I
Know POP up would be yes, but what about sorting?

 

[Jeff Boyce]

Warren

Maybe I misunderstood, but I had the impression you wanted to have something
(a form) pop up, with controls (i.e., "fields") on it that would "collect"
the sorting settings, then open a report that uses the settings on the form
to format itself. What did I miss?

Jeff Boyce
<Access MVP>

 

[Jeff Boyce]

Warren

First, with what we've discussed in this thread, I'd recommend taking your
(revised) question to the .reports newsgroup, more appropriate than a
..tabledbdesign question.

I do want to prime you, though... any criterion on which you want to sort or
group, you'll need to have a data element for. So, in your first example,
selecting all "slow" songs requires that your table(s) record this fact.

Good luck

Jeff Boyce
<Access MVP>